ㅁㄴㅇㄻㄴㅇㄹ
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