비긴, 비건 리팩토링
테이블 (12)
alarm
- id — bigint — 기본 키
- user_id — bigint — 외래 키 → user.id
- is_read — bit
- created_date — datetime(6)
- item_id — bigint — review id / magazine id
- modified_date — datetime(6)
- alarm_type — enum
- content — varchar(255)
- status — enum
block
- id — bigint — 기본 키
- magazine_id — bigint — 외래 키 → magazine.id
- food_id — bigint — 외래 키 → food.id
- sequence — int
- created_date — datetime(6)
- modified_date — datetime(6)
- content — varchar(255)
- status — enum
- is_bold — bit
bookmark
- id — bigint — 기본 키
- content_id — bigint
- created_date — datetime(6)
- modified_date — datetime(6)
- content_type — enum — 매거진 / 레시피 / 레스토랑
- status — enum
- user_id — bigint — 외래 키 → user.id
food
- id — bigint — 기본 키
- modified_date — datetime(6)
- editor — varchar(255)
- name — varchar(255)
- status — enum
- vegan_type — enum
- created_date — datetime(6)
food_ingredient
- id — bigint — 기본 키
- food_id — bigint — 외래 키 → food.id
- created_date — datetime(6)
- modified_date — datetime(6)
- name — varchar(255)
- status — enum
image
- id — bigint — 기본 키
- review_id — bigint — 외래 키 → review.id
- created_date — datetime(6)
- modified_date — datetime(6)
- image_url — varchar(255)
- status — enum
magazine
- id — bigint — 기본 키
- created_date — datetime(6)
- modified_date — datetime(6)
- editor — varchar(255)
- status — enum
- thumbnail — varchar(255)
- title — varchar(255)
menu
- id — bigint — 기본 키
- restaurant_id — bigint — 외래 키 → restaurant.id
- created_date — datetime(6)
- modified_date — datetime(6)
- name — varchar(255)
- status — enum
recommendation
- id — bigint — 기본 키
- user_id — bigint — 외래 키 → user.id
- review_id — bigint — 외래 키 → review.id
- created_date — datetime(6)
- modified_date — datetime(6)
- status — enum
restaurant
- id — bigint — 기본 키
- rate — double
- created_date — datetime(6)
- modified_date — datetime(6)
- city — varchar(255)
- contact_number — varchar(255)
- detail_address — varchar(255)
- kakao_map_url — varchar(255)
- latitude — varchar(255)
- longitude — varchar(255)
- name — varchar(255)
- province — varchar(255)
- restaurant_type — enum
- road_name — varchar(255)
- status — enum
- thumbnail — varchar(255)
- thumbnail_source — varchar(255)
review
- id — bigint — 기본 키
- user_id — bigint — 외래 키 → user.id
- restaurant_id — bigint — 외래 키 → restaurant.id
- rate — double
- visible — bit
- created_date — datetime(6)
- modified_date — datetime(6)
- content — varchar(255)
- review_type — enum
- status — enum
user
- id — bigint — 기본 키
- alarm_setting — bit
- custom_profile_completed — bit
- point — int
- sign_up_completed — bit
- vegan_test_completed — bit
- created_date — datetime(6)
- modified_date — datetime(6)
- email — varchar(255) — NOT NULL
- fcm_token — varchar(255)
- image_url — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- provider — enum
- provider_id — varchar(255)
- role — enum
- status — enum
- user_code — varchar(255)
- user_level — enum
- vegan_type — enum