11

Tables (8)

Admin

  • admin_id — NUMBER
  • username — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(255) — NOT NULL

Artist

  • artist_id — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL

Artwork

  • artwork_id — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • purchase_date — TIMESTAMP

Commission

  • commission_id — NUMBER
  • artist_id2 — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • artist_id — NUMBER
  • title — VARCHAR2(100) — NOT NULL
  • description — CLOB
  • is_active — CHAR(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Inquiry

  • inquiry_id — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • content — CLOB — NOT NULL
  • status — VARCHAR2(20)

Option

  • option_id — NUMBER
  • commission_id — NUMBER
  • artist_id2 — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • option_name — VARCHAR2(100) — NOT NULL
  • price — NUMBER

Request

  • request_id — NUMBER
  • commission_id — NUMBER
  • artist_id2 — NUMBER
  • user_id — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20)
  • created_at — TIMESTAMP

User

  • user_id — VARCHAR2(20) — NOT NULL
  • name — VARCHAR2(20) — NOT NULL
  • birth_date — DATE — NOT NULL
  • email — VARCHAR2(20) — NOT NULL
  • phone_number — VARCHAR2(15)
  • username — VARCHAR2(20) — NOT NULL
  • password — VARCHAR2(20) — NOT NULL
  • is_adult — CHAR(1)