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