pj2
Tables (6)
app_user
- user_id — BIGINT
- email — CITEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- display_name — TEXT
- role — TEXT — NOT NULL
- plan — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
marketplace_order
- order_id — BIGINT
- buyer_id — BIGINT — NOT NULL
- tpl_id — BIGINT — NOT NULL
- price_paid — NUMERIC(12,2) — NOT NULL — 결제
- purchased_at — TIMESTAMPTZ — NOT NULL — 구매
purchase_history
- order_id — BIGINT
- tpl_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- tpl_title — TEXT — NOT NULL
- price_paid — NUMERIC(12,2) — NOT NULL — 결제
- purchased_at — TIMESTAMPTZ — NOT NULL — 구매
sales_history
- order_id — BIGINT
- tpl_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- tpl_title — TEXT — NOT NULL
- price_paid — NUMERIC(12,2) — NOT NULL — 결제
- purchased_at — TIMESTAMPTZ — NOT NULL — 구매
template
- tpl_id — BIGINT
- user_id — BIGINT — NOT NULL
- tpl_title — TEXT — NOT NULL
- description — TEXT
- price — NUMERIC(12,2) — NOT NULL
- rating — NUMERIC(3,2) — NOT NULL
- downloads — INTEGER — NOT NULL
- is_public — BOOLEAN — NOT NULL
- tags — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_template
- user_id — BIGINT — Primary key — NOT NULL
- tpl_id — BIGINT — Primary key — NOT NULL
- user_id2 — BIGINT
- parent_tpl_id — BIGINT