backoffice
테이블 (4)
고객
- id — BIGINT
- name — VARCHAR(50)
- email — VARCHAR(100)
- phone_number — VARCHAR(20)
- status — VARCHAR(20)
- created_at — DATETIME
- modified_at — DATETIME
관리자
- 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
상품
- id — BIGINT
- name — VARCHAR(100)
- category — VARCHAR(50)
- price — BIGINT
- stock — BIGINT
- status — VARCHAR(20)
- admin_id — BIGINT
- created_at — DATETIME
- modified_at — DATETIME
주문
- id — BIGINT
- order_number — VARCHAR(50)
- quantity — BIGINT
- total_price — BIGINT
- status — VARCHAR(20)
- cancel_reason — VARCHAR(255)
- customer_id — BIGINT
- product_id — BIGINT
- admin_id — BIGINT
- created_at — DATETIME
- modified_at — DATETIME
- order_price — BIGINT