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