쇼핑몰

테이블 (8)

Addresses

  • address_id — int auto_increament — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
  • address — text — NOT NULL

Category

  • category_id — int auto_increment — 기본 키 — NOT NULL
  • category_name — varchar(255) — NOT NULL
  • parent (Field) — int
  • created_at (Field2) — Datetime — NOT NULL

Order

  • order_id — int auto_increament — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
  • order_date — datetime — NOT NULL
  • total_money — int — NOT NULL
  • destination — text — NOT NULL

Order_Product

  • order_id — int auto_increament — 외래 키 → Order.order_id — NOT NULL
  • product_id — int auto_increment — 외래 키 → Product.product_id — NOT NULL
  • quantity — int — NOT NULL

PointRecord

  • point_id — int auto_increament — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → User.user_id — NOT NULL
  • whenuse — varchar(50) — NOT NULL
  • plusminus — int — NOT NULL
  • created_at — datetime — NOT NULL

Product

  • product_id — int auto_increment — 기본 키 — NOT NULL
  • product_name — varchar(50) — NOT NULL
  • thumbnail_url — varchar(100)
  • price — decimal — NOT NULL
  • img_url — varchar(100)
  • quantity — int — NOT NULL
  • detail — text — NOT NULL

Product_Category

  • product_id — int auto_increment — 외래 키 → Product.product_id — NOT NULL
  • category_id — int auto_increment — 외래 키 → Category.category_id — NOT NULL

User

  • user_id — varchar(50) — 기본 키 — NOT NULL
  • user_birth — varchar(8) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • user_password — varchar(200) — NOT NULL
  • user_point — int — NOT NULL
  • created_at — datetime — NOT NULL
  • latest_login_at — datetime
  • user_auth — varchar(10) — NOT NULL