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)