qq

Tables (6)

Product

  • product_id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — NOT NULL
  • product_category_id — BIGINT — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • product_price — DECIMAL(10,2)
  • product_short_desc — VARCHAR(255) — NOT NULL
  • product_long_desc — TEXT — NOT NULL
  • product_thumbnail — VARCHAR(500)
  • created_at — DATETIME

ProductImage

  • product_image_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • product_image_link — VARCHAR(500) — NOT NULL

ServiceUser

  • user_id — BIGINT
  • user_pw — VARCHAR(255)
  • user_name — VARCHAR(100) — NOT NULL
  • user_phone — VARCHAR(20) — NOT NULL
  • user_email — VARCHAR(100) — NOT NULL
  • user_age — INT — NOT NULL
  • user_gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • user_role — ENUM('MEMBER', 'MANAGER', 'ADMIN') — NOT NULL
  • user_created_at — DATETIME
  • last_modified_at — DATETIME

Store

  • store_id — BIGINT — Primary key — NOT NULL
  • store_category_id — BIGINT — NOT NULL
  • store_name — VARCHAR(255) — NOT NULL
  • store_short_desc — VARCHAR(255) — NOT NULL
  • store_long_desc — TEXT — NOT NULL
  • store_start — DATE — NOT NULL
  • store_end — DATE — NOT NULL
  • store_thumbnail — VARCHAR(500)

StoreCategory

  • store_category_id — BIGINT — Primary key — NOT NULL
  • store_category_name — VARCHAR(100) — NOT NULL
  • store_category_desc — TEXT

Untitled

  • Key — Primary key — NOT NULL