matji

Tables (6)

Category (식당카테고리)

  • 카테고리id (category_id) — long — Primary key — NOT NULL
  • 카테고리 이름 (name) — String

CategoryRest (카테고리 식당)

  • 카테고리식당id (CategoryRest_id) — long — Primary key — NOT NULL
  • 식당id (restaurant_id) — long — Foreign key → Restaurant.식당id — NOT NULL
  • 카테고리id (category_id) — long — Foreign key → Category.카테고리id — NOT NULL

Comment (댓글)

  • 댓글id (id) — long — Primary key — NOT NULL
  • 식당id (restaurant_id) — long — Foreign key → Restaurant.식당id — NOT NULL
  • 내용 (content) — String
  • 멤버id (member_id) — Long — Foreign key → Member.멤버id — NOT NULL

Member (멤버)

  • 멤버id (member_id) — Long — Primary key — NOT NULL
  • 유저네임 (name) — String
  • 유저이메일 (email) — String
  • 유저비번 (password) — String

Restaurant (식당)

  • 식당id (restaurant_id) — long — Primary key — NOT NULL
  • 식당이름 (name) — String
  • 식당링크 (link) — String
  • 식당위치 (address) — String
  • 식당비고 (note) — String
  • 위도 (latitude) — double
  • 경도 (longtitude) — double

Review (리뷰)

  • 리뷰id (id) — long — Primary key — NOT NULL
  • 별점 (score) — int
  • 식당id (restaurant_id) — long — Foreign key → Restaurant.식당id — NOT NULL
  • 멤버id (member_id) — Long — Foreign key → Member.멤버id — NOT NULL
  • 내용 (content) — String