sibobERD

Tables (8)

bookmark

  • id — BIGINT — Primary key — NOT NULL — 북마크 ID
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 멤버 ID
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — 식당 ID

member

  • id — BIGINT — Primary key — NOT NULL — 멤버 ID
  • email — VARCHAR(45) — NOT NULL — 이메일
  • password — TEXT — NOT NULL — 비밀번호
  • name — VARCHAR(30) — NOT NULL — 이름
  • nickname — VARCHAR(30) — NOT NULL — 닉네임
  • role — VARCHAR(25) — NOT NULL — ADMIN, USER
  • image_url — TEXT — 프로필 이미지 URL
  • status — VARCHAR(15) — NOT NULL — 히스토리 관리
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

menu

  • id — BIGINT — Primary key — NOT NULL — 메뉴 id
  • name — VARCHAR(50) — NOT NULL — 메뉴명
  • menu_date — DATE — NOT NULL — 중식, 석식 등등
  • content — TEXT — NOT NULL — 메뉴내용
  • calorie — DECIMAL(5, 1) — 칼로리
  • image — TEXT — 식단 이미지
  • origin — TEXT — 원산지
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — 식당 ID

review

  • id — BIGINT — Primary key — NOT NULL — 리뷰 ID
  • comment — TEXT — NOT NULL — 내용
  • score — TINYINT — NOT NULL — 별점
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — 식당 ID
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 멤버 ID

station

  • id — BIGINT — Primary key — NOT NULL — 역 ID
  • name — VARCHAR(30) — NOT NULL — 이름
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

store

  • id — BIGINT — Primary key — NOT NULL — 식당 ID
  • name — VARCHAR(100) — NOT NULL — 업체명
  • price — INT — NOT NULL — 가격
  • score — DECIMAL(2, 1) — NOT NULL — 별점
  • type — VARCHAR(20) — NOT NULL — 점심뷔페, 구내식당
  • park_area — VARCHAR(40) — NOT NULL — 주차
  • toilet — VARCHAR(40) — NOT NULL — 화장실
  • hours — VARCHAR(100) — NOT NULL — 영업시간
  • station — BIGINT — NOT NULL — N:M
  • member_id — BIGINT — NOT NULL — 관리자 여부
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

store_image

  • id — BIGINT — Primary key — NOT NULL — 식당 이미지 ID
  • url — TEXT — NOT NULL — 식당 이미지 URL
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — 식당 ID

store_station

  • store_station_id — BIGINT — Primary key — NOT NULL — 식당_역 관계 ID
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • station_id — BIGINT — Foreign key → station.id — NOT NULL — 역 ID
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — 식당 ID