CAMEET

Tables (6)

APPLY (Untitled2)

  • 지원번호 (Key) — Primary key — NOT NULL
  • 방번호 (Key2) — Foreign key → ROOM.방번호 — NOT NULL
  • USER_EMAIL (Key4) — Foreign key → USER.USER_EMAIL — NOT NULL

REVIEW (Untitled4)

  • 리뷰번호 (Key) — Primary key — NOT NULL
  • 방번호 (Field)
  • 작성자 (Field2)
  • 내용 (Field3)
  • 방번호 (Key2) — Foreign key → ROOM.방번호 — NOT NULL

ROOM (Untitled)

  • 방번호 (Key) — Primary key — NOT NULL
  • 정원 (Field2)
  • USER_EMAIL (Key3) — Foreign key → USER.USER_EMAIL — NOT NULL

USER (Untitled3)

  • USER_EMAIL (Key) — Primary key — NOT NULL
  • 이름 (Field)

USER (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • EMAIL (Field)
  • NICKNAME (Field2)

USER_SOCIAL_KAKAO (Untitled6)

  • ACCESS_TOKEN (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → USER.ID — NOT NULL
  • TYPE (Field2)