my

Tables (6)

cart_item_tb (Untitled4)

  • id (primary key) — bigint — Primary key — NOT NULL — PK
  • user_id (Key) — bigint — Foreign key → user_tb.id — NOT NULL — PK
  • option_id (Key4) — bigint — Foreign key → option_tb.id — NOT NULL — PK
  • quantity (Foreign key) — int — NOT NULL

option_tb (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • product_id (Key2) — bigint — Foreign key → product_tb.id — NOT NULL — PK
  • name (Field) — varchar(100) — NOT NULL
  • price (Field2) — int — NOT NULL
  • create_date (Field3) — datetime — NOT NULL
  • update_date (Field4) — datetime — NOT NULL

order_item_tb (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • order_id (Key2) — bigint — Foreign key → order_tb.id — NOT NULL — PK
  • option_id (Key3) — bigint — Foreign key → option_tb.id — NOT NULL — PK
  • quantity (Field) — int — NOT NULL
  • price (Field2) — int — NOT NULL

order_tb (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • user_id (Key3) — bigint — Foreign key → user_tb.id — NOT NULL — PK
  • order_date (Field) — datetime — NOT NULL

product_tb (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • name (Field) — varchar(100) — NOT NULL
  • description (Field6) — varchar(1000) — NOT NULL
  • image (Field2) — varchar(200) — NOT NULL
  • price (Field3) — int — NOT NULL
  • create_date (Field4) — datetime — NOT NULL
  • update_date (Field5) — datetime — NOT NULL

user_tb (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • username (Field) — varchar(20) — NOT NULL
  • email (Field2) — varchar(100) — NOT NULL
  • password (Field3) — varchar(256) — NOT NULL
  • join_date (Field4) — datetime — NOT NULL
  • role (Field5) — varchar(20) — NOT NULL