Food-mission-app
Tables (11)
favorite_category
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- food_category_id — bigint — Foreign key → food_category.id — NOT NULL
food_category
- id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
inquiry
- id — bigint — Primary key — NOT NULL
- type — varchar(10)
- title — text
- content — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- status — tinyint(2)
- member_id — bigint — Foreign key → member.id — NOT NULL
inquiry_image
- id — bigint — Primary key — NOT NULL
- image — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- status — tinyint(2)
- inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL
member
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- nickname — varchar(20) — NOT NULL
- gender — tinyint(1) — NOT NULL
- birthday — datetime() — NOT NULL
- address — text — NOT NULL
- phone_no — varchar(11)
- point — int — NOT NULL
- login_method — varchar(10)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- status — varchar(10) — NOT NULL
- inactive_date — datetime()
menu
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
- descript — text
- price — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
mission
- id — bigint — Primary key — NOT NULL
- price — int — NOT NULL
- point — int — NOT NULL
- location — text
- due_date — datetime()
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
my_mission
- id — bigint — Primary key — NOT NULL
- status — tinyint(2)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
restaurant
- id — bigint — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- address — text — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- food_category_id — bigint — Foreign key → food_category.id — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- review_text — text
- score — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
review_image
- id — bigint — Primary key — NOT NULL
- image — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- review_id — bigint — Foreign key → review.id — NOT NULL