shopping-mall-final

Tables (10)

cart_items

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • quantity — int — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

members

  • id — bigint — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • gender — varchar(255) — NOT NULL
  • birth_date — date — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

order_items

  • id — bigint — NOT NULL
  • order_id — bigint
  • product_id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — bigint — NOT NULL
  • image_file_name — varchar(255) — NOT NULL
  • quantity — int — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

order_stats

  • id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • birth_year_range — varchar(255) — NOT NULL
  • gender — varchar(255) — NOT NULL
  • count — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

orders

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • status — varchar(255) — NOT NULL
  • pay_type — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

pays

  • id — bigint — NOT NULL
  • order_id — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

points

  • id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • point — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

products

  • id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — bigint — NOT NULL
  • image_file_name — varchar(255) — NOT NULL
  • stock — int — NOT NULL
  • description — text — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

rate_stats

  • id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • birth_year_range — varchar(255) — NOT NULL
  • gender — varchar(255) — NOT NULL
  • total_score — bigint — NOT NULL
  • count — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL

rates

  • id — bigint — NOT NULL
  • order_item_id — bigint — NOT NULL
  • score — smallint — NOT NULL
  • created_at — datetime — NOT NULL
  • last_modified_at — datetime — NOT NULL