ssok-gemini

Tables (6)

artists

  • artist_id — SERIAL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • profile_img — TEXT
  • bio — TEXT
  • is_verified — BOOLEAN
  • royalty_rate — DECIMAL(5, 2)

funding_projects

  • project_id — SERIAL
  • creator_id — INT — Foreign key → users.user_id — NOT NULL
  • artist_id — INT — Foreign key → artists.artist_id — NOT NULL
  • vendor_id — INT — Foreign key → vendors.vendor_id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • ai_image_url — TEXT — NOT NULL
  • status — VARCHAR(30)
  • max_unit_price — INT — NOT NULL
  • target_date — TIMESTAMP
  • current_count — INT
  • created_at — TIMESTAMP

orders

  • order_id — SERIAL
  • project_id — INT — Foreign key → funding_projects.project_id — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • total_paid — INT — NOT NULL
  • refund_amount — INT
  • status — VARCHAR(20)
  • tracking_number — VARCHAR(100)
  • address — TEXT — NOT NULL
  • ordered_at — TIMESTAMP

users

  • user_id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • role — VARCHAR(20)
  • created_at — TIMESTAMP

vendor_products

  • v_prod_id — SERIAL
  • vendor_id — INT — Foreign key → vendors.vendor_id — NOT NULL
  • category_name — VARCHAR(50)
  • min_quantity — INT — NOT NULL
  • max_quantity — INT — NOT NULL
  • price_per_unit — INT — NOT NULL

vendors

  • vendor_id — SERIAL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • company_name — VARCHAR(100)
  • shipping_fee — INT
  • weekly_min_capacity — INT
  • weekly_max_capacity — INT