Shop

Tables (8)

Category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)

Delivery

  • delivery_id — BIGINT — Primary key — NOT NULL
  • address — VARCHAR(255)
  • status — VARCHAR(255)

HairItem

  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • sub_category_id — BIGINT — Foreign key → SubCategory.sub_category_id — NOT NULL
  • category_id — BIGINT — Foreign key → SubCategory.category_id — NOT NULL

Item

  • item_id — BIGINT — Primary key — NOT NULL
  • dtype — VARCHAR(31)
  • name — VARCHAR(255)
  • price — INT
  • stockQuantity — INT
  • brandName — VARCHAR(255)

Member

  • member_id — BIGINT — Primary key — NOT NULL
  • userId — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • age — BIGINT
  • phone — VARCHAR(255)
  • isAdmin — BOOLEAN
  • status — VARCHAR(255)

Order

  • order_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
  • delivery_id — BIGINT — Foreign key → Delivery.delivery_id — NOT NULL
  • orderDate — TIMESTAMP
  • status — VARCHAR(255)

OrderItem

  • order_item_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → Item.item_id — NOT NULL
  • order_id — BIGINT — Foreign key → Order.order_id — NOT NULL
  • count — INT
  • orderPrice — INT

SubCategory

  • sub_category_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → Category.category_id — NOT NULL
  • name — VARCHAR(255)