flora
Tables (9)
advertisement (광고)
- PK (ad_id) — INT — Primary key — NOT NULL
- FK (shop_id) — INT — Foreign key → flowershop.PK — NOT NULL
- 광고이미지 (ad_image) — BLOB
- 생성날짜 (created_date) — DATE
flower (꽃)
- PK (flower_id) — INT — Primary key — NOT NULL
- 꽃이름 (flower_name) — VARCHAR(50)
- 꽃말 (flower_lang) — VARCHAR(50)
- 꽃이미지 (flower_image) — BLOB
flower_custom (커스터마이징)
- PK (custom_id) — INT — Primary key — NOT NULL
- FK (shop_id) — INT — Foreign key → flowershop.PK — NOT NULL
- FK (flower_id) — INT — Foreign key → flower.PK — NOT NULL
- 꽃 가격 (flower_price) — INT
flowershop (꽃집)
- PK (shop_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → user.PK — NOT NULL
- 가게이름 (shop_name) — VARCHAR(50)
- 가게주소 (shop_address) — VARCHAR(50)
- 가게전화번호 (shop_number) — VARCHAR(20)
- 가게오픈시간 (shop_open_time) — TIME
- 가게닫는시간 (shop_close_time) — TIME
- 가게이미지 (shop_image) — BLOB
- 가게소개 (shop_description) — LONGTEXT
- 생성날짜 (created_date) — DATE
location (꽃집위치)
- PK (location_id) — INT — Primary key — NOT NULL
- FK (shop_id) — INT — Foreign key → flowershop.PK — NOT NULL
- 가게경도 (location_longtitude) — DECIMAL(13,10)
- 가게위도 (location_latitude) — DECIMAL(13,10)
order (주문)
- PK (order_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → user.PK — NOT NULL
- FK (shop_id) — INT — Foreign key → flowershop.PK — NOT NULL
- 주문날짜 (created_date) — DATETIME
- 픽업날짜 (pickup_time) — DATETIME
- 결제금액 (total_price) — INT
order_flower_custom (주문상품)
- PK (orderlist_id) — INT — Primary key — NOT NULL
- FK (order_id) — INT — Foreign key → order.PK — NOT NULL
- FK (custom_id) — INT — Foreign key → flower_custom.PK — NOT NULL
- 수량 (count) — INT
- 주문금액 (order_price) — INT
review (리뷰)
- PK (review_id) — INT — Primary key — NOT NULL
- FK (user_id) — INT — Foreign key → user.PK — NOT NULL
- FK (shop_id) — INT — Foreign key → flowershop.PK — NOT NULL
- 리뷰제목 (review_title) — VARCHAR(50)
- 리뷰내용 (review_content) — LONGTEXT
- 리뷰이미지 (review_image) — BLOB
- 리뷰점수 (review_score) — INT
- 생성날짜 (created_date) — DATETIME
user (회원)
- PK (user_id) — INT — Primary key — NOT NULL
- 유저명 (user_name) — VARCHAR(50)
- 이메일 (email) — VARCHAR(50)
- 비밀번호 (password) — VARCHAR(50)
- 성별 (gender) — INT
- 생년월일 (birthday) — DATE
- 전화번호 (phone_number) — VARCHAR(20)
- 역할 (role) — VARCHAR(50)
- 생성날짜 (created_date) — DATE