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