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