브피

테이블 (10)

bakery

  • bakery_id — BIGINT — 기본 키 — NOT NULL
  • deleted_at — BIT(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • name — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • business_hours — VARCHAR(255)
  • best_bread — VARCHAR(255)
  • is_drink — BIT(1)
  • is_eat_in — BIT(1)
  • is_waiting — BIT(1)
  • is_parking — BIT(1)
  • x_coordinate — DOUBLE
  • y_coordinate — DOUBLE
  • member_id — BIGINT
  • detail — VARCHAR(255)
  • lot_number — VARCHAR(255)
  • road_address — VARCHAR(255)

diary

  • diary_id — BIGINT — 기본 키 — NOT NULL
  • deleted_at — BIT(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • thumb_url — VARCHAR(255)
  • ispublic — BIT(1)
  • visit_date — datetime
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • drawing_data — LONGTEXT
  • detail — VARCHAR(255)
  • lot_number — VARCHAR(255)
  • road_address — VARCHAR(255)
  • bakery_id (bakery_id2) — BIGINT — 외래 키 → bakery.bakery_id — NOT NULL
  • member_id (member_id2) — BIGINT — 외래 키 → member.member_id — NOT NULL

hashtag

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • diary_id — BIGINT — 외래 키 → diary.diary_id — NOT NULL

likes

  • id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • member_id — BIGINT
  • bakery_id — BIGINT — 외래 키 → bakery.bakery_id — NOT NULL
  • member_id (member_id2) — BIGINT — 외래 키 → member.member_id — NOT NULL

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • nickname — VARCHAR(255)
  • location — VARCHAR(255)
  • email — VARCHAR(255)
  • role — VARCHAR(255)
  • kakao_id — BIGINT

menu

  • menu_id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • thumbnail_url — VARCHAR(255) — NOT NULL
  • is_representation — BIT(1) — NOT NULL
  • bakery_id (bakery_id2) — BIGINT — 외래 키 → bakery.bakery_id — NOT NULL

picture_url

  • id — BIGINT — 기본 키 — NOT NULL
  • pic_url — VARCHAR(255) — NOT NULL
  • diary_id — BIGINT — 외래 키 → diary.diary_id — NOT NULL

review

  • review_id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • content — VARCHAR(255) — NOT NULL
  • rating — DOUBLE — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • bakery_id — BIGINT — 외래 키 → bakery.bakery_id — NOT NULL

review_likes (CopyOflikes)

  • id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • member_id — BIGINT
  • member_id (member_id2) — BIGINT — 외래 키 → member.member_id — NOT NULL
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL

reviewpicture_url

  • id — BIGINT — 기본 키 — NOT NULL
  • pic_url — VARCHAR(255) — NOT NULL
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL