asd
Tables (4)
ADMIN (관리자)
- id — BIGINT
- name — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(255)
- phone_number — VARCHAR(20)
- role — VARCHAR(20)
- status — VARCHAR(20)
- approved_at — DATETIME
- rejected_at — DATETIME
- rejection_reason — VARCHAR(255)
- created_at — DATETIME
- modified_at — DATETIME
CUSTOMER (고객)
- id — BIGINT
- name — VARCHAR(50)
- email — VARCHAR(100)
- phone_number — VARCHAR(20)
- status — VARCHAR(20)
- created_at — DATETIME
- modified_at — DATETIME
ORDERS (주문)
- id — BIGINT
- order_number — VARCHAR(50)
- quantity — BIGINT
- total_price — BIGINT
- status — VARCHAR(20)
- cancel_reason — VARCHAR(255)
- customer_id — BIGINT — Foreign key → CUSTOMER.id
- product_id — BIGINT — Foreign key → PRODUCT.id
- admin_id — BIGINT — Foreign key → ADMIN.id
- created_at — DATETIME
- modified_at — DATETIME
- order_price — BIGINT
PRODUCT (상품)
- id — BIGINT
- name — VARCHAR(100)
- category — VARCHAR(50)
- price — BIGINT
- stock — BIGINT
- status — VARCHAR(20)
- admin_id — BIGINT — Foreign key → ADMIN.id
- created_at — DATETIME
- modified_at — DATETIME