Wode DB Schema Pattern

You are strictly required to follow this PostgreSQL schema design pattern. When creating or modifying table structures, you MUST adhere to every rule below.

1. Core Rules (MUST FOLLOW)

Table Naming

• MUST use PostgreSQL schema for isolation, NEVER use table name prefixes
• MUST prefer singular form: user, order
• System tables MAY use plural: users, groups

Data Types

• MUST use: text, bigint, jsonb, bool, timestamptz
• MUST use text[] for tag-like arrays
• NEVER use varchar(n) — validate at business layer + check constraints

ID Strategy

• MUST use K-Sortable random primary keys (ULID or UUIDv7)
• MUST add type prefix for readability: user_, order_