commerce
Tables (5)
admin
- id — BigInt — Primary key — NOT NULL
- name — Varchar(50)
- email — Varchar(100)
- password — Varchar(255)
- phone — Varchar(20)
- role — Varchar(20)
- status (Field3) — Varchar(20)
- rejection_reason (Field5) — Varchar(255)
- deleted (Field6) — Is_Deleted
- created_at (Field) — TimeStamp
- approved_at (Field2) — DateTime
- deleted_at (Field7) — DataTime
- updated_at (Field8) — DataTime
- rejected_at (Field4) — DateTime
customer
- id — BigInt — Primary key — NOT NULL
- name — Varchar(50)
- email — Varchar(100)
- phone — Varchar(20)
- status — Varchar(20)
- created_at — TimeStamp
- deleted (Field) — Is_Deleted
- deleted_at (Field2) — DataTime
- updated_at (Field3) — DataTime
item
- id — BigInt — Primary key — NOT NULL
- admin_id (id2) — BigInt(FK) — Foreign key → admin.id — NOT NULL
- name — Varchar(100)
- category — Varchar(50)
- price — Int
- stock — Int
- status — Varchar(20)
- created_at (Field) — TimeStamp
- deleted (Field4) — Is_Deleted
- deleted_at (Field5) — DataTime
- updated_at (Field2) — DataTime
order
- id — BigInt — Primary key — NOT NULL
- admin_id — BigInt (FK, Null 허용) — Foreign key → admin.id — NOT NULL
- customer_id — BigInt (FK) — Foreign key → customer.id — NOT NULL
- item_id — BigInt (FK) — Foreign key → item.id — NOT NULL
- order_number — Varchar(50)
- total_price (Field4) — BigInt
- quantity — Int
- created_at (Field5) — TimeStamp
- updated_at (Field6) — DataTime
- status — Varchar(20)
- deleted (Field) — Is_Deleted
- deleted_at (Field2) — DataTime
- cancel_reason (Field3) — Varchar(255)
review (Untitled)
- id (Key) — BigInt — Primary key — NOT NULL
- order_id (id) — BigInt(FK) — Foreign key → order.id — NOT NULL
- item_id (id2) — BigInt(FK) — Foreign key → item.id — NOT NULL
- customer_id (id3) — BigInt(FK) — Foreign key → customer.id — NOT NULL
- rating (Field) — Int
- content (Field2) — Varchar(255)
- created_at (Field3) — TimeStamp
- deleted (Field4) — Is_Deleted
- deleted_at (Field5) — DataTime
- updated_at (Field6) — DataTime