ㅇㅇ

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