ㅁㄴㅇㄻㄴㅇㄹ

Tables (10)

addr

  • 삭제 여부 (is_delete) — bit
  • 주소 ID (addr_id) — bigint
  • 생성 날짜 (create_date) — datetime(6)
  • 수정 날짜 (last_modify_date) — datetime(6)
  • 회원ID (member_id) — bigint
  • 주소 (addr) — varchar(255) — NOT NULL
  • 주소 상세 (addr_detail) — varchar(255) — NOT NULL

cart

  • cart_status — tinyint — NOT NULL
  • is_delete — bit
  • cart_id — bigint
  • create_date — datetime(6)
  • last_modify_date — datetime(6)
  • member_id — bigint
  • check — (`cart_status` between 0 and 1)

cart_detail

  • amount — int — NOT NULL
  • is_delete — bit
  • cart_detail_id — bigint
  • cart_id — bigint
  • create_date — datetime(6)
  • item_id — bigint
  • last_modify_date — datetime(6)

item

  • is_delete — bit
  • item_status — tinyint — NOT NULL
  • create_date — datetime(6)
  • item_id — bigint
  • item_type_id — bigint
  • last_modify_date — datetime(6)
  • item_name — varchar(255) — NOT NULL
  • item_details — tinytext — NOT NULL
  • check — (`item_status` between 0 and 4)

item_image

  • image_ordering — tinyint — NOT NULL
  • is_delete — bit
  • item_image_type — tinyint — NOT NULL
  • create_date — datetime(6)
  • item_id — bigint
  • item_image_id — bigint
  • last_modify_date — datetime(6)
  • image_path — tinytext — NOT NULL
  • check — (`item_image_type` between 0 and 1)

item_type

  • is_delete — bit
  • create_date — datetime(6)
  • item_type_id — bigint
  • last_modify_date — datetime(6)
  • item_type_name — varchar(255) — NOT NULL

member

  • 삭제 여부 (is_delete) — bit
  • create_date — datetime(6)
  • last_modify_date — datetime(6)
  • member_id — bigint
  • email — varchar(255) — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • member_name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • role — enum

order

  • is_delete — bit
  • order_status — tinyint — NOT NULL
  • create_date — datetime(6)
  • last_modify_date — datetime(6)
  • member_id — bigint
  • order_id — bigint
  • order_addr — varchar(255) — NOT NULL
  • check — (`order_status` between 0 and 6)

order_detail

  • amount — int — NOT NULL
  • is_delete — bit
  • create_date — datetime(6)
  • item_id — bigint
  • last_modify_date — datetime(6)
  • order_detail_id — bigint
  • order_id — bigint

wish_list

  • is_checked — bit — NOT NULL
  • is_delete — bit
  • create_date — datetime(6)
  • item_id — bigint
  • last_modify_date — datetime(6)
  • member_id — bigint
  • wish_list_id — bigint