ㅇㅇ
Tables (6)
Article
- article_id — Integer — Primary key — NOT NULL
- restaurant_id — Integer — Foreign key → Restaurant.restaurant_id — NOT NULL
- user_id — Integer — Foreign key → User.user_id
- type_article — Integer — NOT NULL — 0:리뷰글 1:청원글
- title — Text — NOT NULL
- content — Text — NOT NULL
- liked_user_number — Integer
- comment_number — Integer
Comment
- comment_id — Integer — Primary key — NOT NULL
- article_id — Integer — Foreign key → Article.article_id — NOT NULL
- user_id — Integer — Foreign key → User.user_id
- content — Text
- liked_user_number — Integer
- type_comment — Integer — NOT NULL — 댓글인지 대댓글인지 판단
LikesRestaurant
- restaurant_id — Integer — Foreign key → Restaurant.restaurant_id — NOT NULL
- user_id — Integer — Foreign key → User.user_id
Menu
- name — Text — Primary key — NOT NULL
- restaurant_name — Text — Primary key — NOT NULL
- restaurant_id — Integer — Foreign key → Restaurant.restaurant_id — NOT NULL
- price — Integer — NOT NULL
- content — Text — 옵션 적거나 메뉴설명 적거나
- signature — Integer — 0:일반 메뉴 1:대표 메뉴
Restaurant
- restaurant_id — Integer — Primary key — NOT NULL
- name — Text — NOT NULL
- location — Text — NOT NULL
- article_number — Integer
- rating — Float
- tag_loc — Text — NOT NULL
- tag_food — Text — NOT NULL
User
- user_id — Integer
- email — Text — NOT NULL
- password — Text — NOT NULL
- name — Text — NOT NULL
- nickname — Text — NOT NULL
- grade — Integer — NOT NULL
- is_authorized — Integer — 0:인증x 1:인증0