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