SHOP
Tables (6)
cart_item (Untitled3)
- cart_item_id (Key) — bigint — Primary key — NOT NULL
- member_id (member_id2) — bigint — Foreign key → member.member_id — NOT NULL — Auto_increament
- item_id (member_id) — bigint — Foreign key → item.item_id — NOT NULL — Auto_increament
- count (Field) — int — NOT NULL
item (CopyOfMember)
- item_id (member_id) — bigint — Primary key — NOT NULL — Auto_increament
- name (Field2) — varchar — NOT NULL
- price (Field5) — varchar — NOT NULL
- quantity (Field6) — int — NOT NULL
- content (Field) — varchar — NOT NULL
- create_date (Field4) — date — NOT NULL
- update_date (Field3) — date — NOT NULL
item_img (Untitled)
- item_img_id (Key) — bigint — Primary key — NOT NULL
- item_id (member_id) — bigint — Foreign key → item.item_id — Auto_increament
- img_name (Field2) — varchar — NOT NULL
- origin_img_name (Field5) — varchar — NOT NULL
- path (Field3) — varchar — NOT NULL
- order (Field6) — int — NOT NULL
- create_date (Field7) — datetime — NOT NULL
- update_date (Field8) — datetime — NOT NULL
member (Member)
- member_id — bigint — Primary key — NOT NULL — Auto_increament
- email (Field2) — varchar — NOT NULL
- password (Field5) — varchar — NOT NULL
- name (Field) — varchar — NOT NULL
- adress (Field4) — varchar — NOT NULL
- role (Field3) — varchar — NOT NULL
order_item (Untitled5)
- order_item_id (Key) — bigint — Primary key — NOT NULL
- orders_id (Key2) — bigint — Foreign key → orders.orders_id — NOT NULL
- item_id (member_id) — bigint — Foreign key → item.item_id — Auto_increament
- item_img_id (Key3) — bigint — Foreign key → item_img.item_img_id
- order_item_name (Field) — varchar — NOT NULL
- order_price (Field3) — int — NOT NULL
- count (Field2) — int — NOT NULL
orders (Untitled4)
- orders_id (Key) — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL — Auto_increament
- date (Field) — datetime — NOT NULL
- status (Field2) — varchar — NOT NULL