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 — 작성일시