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