TASK
Tables (5)
CATEGORY
- CATEGORY_ID — NUMBER
- NAME — VARCHAR2(50) — NOT NULL — 카테고리명(한식
FAVORITE
- FAVORITE_ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL — 회원
- RESTAURANT_ID — NUMBER — Foreign key → RESTAURANT.RESTAURANT_ID — NOT NULL — 맛집
- CREATED_AT — TIMESTAMP — NOT NULL — 찜한
MEMBER
- MEMBER_ID — NUMBER
- EMAIL — VARCHAR2(100) — NOT NULL — 이메일(로그인
- PASSWORD — VARCHAR2(255) — NOT NULL — 암호화된
- NICKNAME — VARCHAR2(50) — NOT NULL — 닉네임
- PROFILE_IMAGE — VARCHAR2(1000) — 프로필
- CREATED_AT — TIMESTAMP — NOT NULL — 가입일시
RESTAURANT
- RESTAURANT_ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — 등록한
- CATEGORY_ID — NUMBER — Foreign key → CATEGORY.CATEGORY_ID — 카테고리
- NAME — VARCHAR2(150) — NOT NULL — 상호명
- ADDRESS — VARCHAR2(300) — NOT NULL — 주소
- REPRESENTATIVE_IMAGE — VARCHAR2(1000) — 대표
- CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
REVIEW
- REVIEW_ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL — 작성한
- RESTAURANT_ID — NUMBER — Foreign key → RESTAURANT.RESTAURANT_ID — NOT NULL — 대상
- RATING — NUMBER(1) — NOT NULL — 별점(1~5)
- CONTENT — VARCHAR2(4000) — NOT NULL — 리뷰
- CREATED_AT — TIMESTAMP — NOT NULL — 작성일시