Table users {
  id            int [pk]
  email         varchar
  password      varchar
  name          varchar
  phone_number  varchar
  address       varchar 
  created_at    datetime
  updated_at    datetime
  deleted_at    datetime // default : null
}

Table categories_main{
  id    int [pk]
  name  varchar
}

Table categories_sub{
  main_id   int [not null,ref: > categories_main.id]
  id        int [pk]
  name      varchar
}

Table products {
  categories_id         int [not null, ref: > categories_sub.id]
  id                    int [pk]
  serial                varchar // serial DD1579-001
  title                 varchar
  sub_title             varchar
  price                 decimal
  thumbnail             varchar // 썸네일 이미지
  quantity              int     // 수량
  eco_friendly          boolean
  current_color         varchar // 현재 컬러: 화이트/메탈릭 골드/플라이트 골드
  description_title     varchar
  description           varchar
}

Table product_options {
    id           int [pk] 
    products_id  int [not null,ref: > products.id]
    colors_id    int [not null,ref: > colors.id]
    sizes_id     int [not null,ref: > sizes.id]
    quantity     int
}

Table colors {
  id          int [pk]
  name        varchar // red, black...
}
Table sizes {
    id       int [pk]
    name     varchar // s, m, l, xl, 230, 240,250 ...
}

Table product_images {
  products_id int [not null,ref: > products.id]
  id          int[pk]
  main_yn     char      // seq // 메인 이미지 노출 YN
  url         varchar
}

Table shopping_carts {
  po_id        int [not null,ref: > product_options.id]
  users_id     int [not null,ref: > users.id]
  id           int [pk]
  quantity     int       
  created_at   datetime
  updated_at   datetime
  deleted_at   datetime 
}

Table orders {
  po_id         int [not null,ref: > product_options.id]
  id            int [pk] // 주문번호 형식: 2021-11-01_0001 
  order_number  varchar  // unique value
  status        int 
  address       varchar
  created_at    datetime
  updated_at    datetime
  deleted_at    datetime
}

Table reviews {
  po_id         int [not null,ref: > product_options.id]
  user_id       int [not null,ref: > users.id]
  id            int [pk]
  title         varchar
  text          varchar
  rating        int       // 4.5
  created_at    datetime
  updated_at    datetime
  deleted_at    datetime
}

Table review_images {
  reviews_id int [not null,ref: > reviews.id]
  id          int[pk]
  url         varchar
}