브피
테이블 (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