food
Tables (5)
campus
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
category
- id — bigint — Primary key — NOT NULL
- name — varchar(10)
member
- id — bigint — Primary key — NOT NULL
- github_id — varchar(255)
- username — varchar(255)
- profile_image — varchar(255)
restaurant
- id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → category.id — NOT NULL
- campus_id — bigint — Foreign key → campus.id — NOT NULL
- name — varchar(20)
- address — varchar(255)
- distance — bigint
- kakao_map_url — varchar(255)
- image_url — varchar(255) — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
- content — varchar(255)
- score — int
- menu — varchar(20)