팜컴어스
테이블 (11)
cart_list
- cart_id — bigint — 기본 키 — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
- member_id — bigint — NOT NULL
- item_id — bigint — NOT NULL
- cart_item_count — int
category
- category_id — bigint — 기본 키 — NOT NULL
- category_name — varchar(25) — NOT NULL
delivery_info
- delivery_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- delivery_addr — VARCHAR(255) — NOT NULL
- delivery_name — VARCHAR(10) — NOT NULL
- delivery_phone_number — VARCHAR(15) — NOT NULL
- order_id — bigint — 외래 키 → order_info.order_id — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → order_info.member_id — NOT NULL
- oitem_id — bigint — 외래 키 → order_info.oitem_id — NOT NULL
item
- item_id — BIGINT — 기본 키 — NOT NULL
- item_name — VARCHAR(25) — NOT NULL
- item_description — VARCHAR(255) — NOT NULL
- item_img — VARCHAR(255) — NOT NULL
- item_price — INT — NOT NULL
- item_discount — INT
- category_id — BIGINT — 외래 키 → category.category_id — NOT NULL
- store_id — BIGINT — 외래 키 → store.store_id — NOT NULL
- item_created_at — DATETIME — NOT NULL
- slike_id — bigint — 외래 키 → store.slike_id — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → store.member_id — NOT NULL
live
- live_id — bigint — 기본 키 — NOT NULL
- store_id (store_id2) — BIGINT — 외래 키 → store.store_id — NOT NULL
- slike_id — bigint — 외래 키 → store.slike_id — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → store.member_id — NOT NULL
- item_id — bigint — NOT NULL
- live_start — datetime — NOT NULL
- live_end — datetime — NOT NULL
- live_discount — int
- store_id — bigint — NOT NULL
member
- member_id — BigInt — 기본 키 — NOT NULL
- nickname — varchar(10) — NOT NULL
- email — varchar(30) — NOT NULL
- profile_img — varchar(255)
- exist_store — boolean — NOT NULL
- street_addr — varchar(50) — NOT NULL
- zipcode — varchar(10) — NOT NULL
- detailed_addr — varchar(50) — NOT NULL
- access_token — varchar(255)
- phone_number — varchar(15) — NOT NULL
order_info
- order_id — bigint — 기본 키 — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
- oitem_id — bigint — 외래 키 → order_item.oitem_id — NOT NULL
- member_id — bigint — NOT NULL
- delivery_id — bigint — NOT NULL
- order_created_at — datetime — NOT NULL
order_item
- oitem_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — NOT NULL
- item_id — bigint — NOT NULL
- store_id — bigint — NOT NULL
- oitem_count — int
- oitem_status — varchar(10)
- oitem_created_at — datetime — NOT NULL
reserved_live
- reserved_live_id — bigint — 기본 키 — NOT NULL
- live_id (live_id2) — bigint — 외래 키 → live.live_id — NOT NULL
- store_id (store_id2) — BIGINT — 외래 키 → live.store_id — NOT NULL
- slike_id — bigint — 외래 키 → live.slike_id — NOT NULL
- member_id (member_id22) — BigInt — 외래 키 → live.member_id — NOT NULL
- member_id — bigint — NOT NULL
- live_id — bigint — NOT NULL
- reserved_live_start — datetime — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
store
- store_id — BIGINT — 기본 키 — NOT NULL
- slike_id — bigint — 외래 키 → store_like.slike_id — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → store_like.member_id — NOT NULL
- store_name — VARCHAR(15) — NOT NULL
- store_description — VARCHAR(255) — NOT NULL
- store_img — VARCHAR(255) — NOT NULL
- store_street_addr — VARCHAR(50) — NOT NULL
- store_detail_addr — VARCHAR(50) — NOT NULL
- store_zipcode — VARCHAR(10) — NOT NULL
- store_phone_number — VARCHAR(15) — NOT NULL
- sotre_created_at — DATETIME — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
store_like
- slike_id — bigint — 기본 키 — NOT NULL
- member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
- member_id — bigint — NOT NULL
- store_id — bigint — NOT NULL