mew

Tables (5)

cart (Cart)

  • id (cart_id) — BIGINT — Primary key — NOT NULL
  • count — INT
  • createdDate (created_date) — DATETIME
  • modifiedDate (modified_date) — DATETIME
  • id (item_id) — BIGINT — Foreign key → item.id — NOT NULL
  • id (user_id) — BIGINT — Foreign key → user.id — NOT NULL
  • id (orderitem_id) — BIGINT — Foreign key → orderitem.id — NOT NULL

item (Item)

  • id (item_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • category — VARCHAR
  • price — VARCHAR
  • img — INT
  • createdDate (created_date) — DATETIME
  • modifiedDate (modified_date) — DATETIME

orderitem (OrderItem)

  • id (orderitem_id) — BIGINT — Primary key — NOT NULL
  • address — VARCHAR
  • message — VARCHAR
  • amount — INT
  • orderName (order_name) — VARCHAR
  • orderNumber (order_number) — VARCHAR
  • createdDate (created_date) — DATETIME
  • modifiedDate (modified_date) — DATETIME
  • id (user_id) — BIGINT — Foreign key → user.id — NOT NULL

review (Review)

  • id (review_id) — BIGINT — Primary key — NOT NULL
  • content — LONGTEXTT
  • rate — INT
  • createdDate (created_date) — DATETIME
  • modifiedDate (modified_date) — DATETIME
  • id (item_id) — BIGINT — Foreign key → item.id — NOT NULL
  • id (user_id) — BIGINT — Foreign key → user.id — NOT NULL

user (User)

  • id (user_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • email — VARCHAR
  • password — VARCHAR
  • address — VARCHAR
  • createdDate (created_date) — DATETIME
  • modifiedDate (modified_date) — DATETIME