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)