클론5조

테이블 (6)

BOOK (Untitled6)

  • BOOK_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • USER_ID (Key2) — BIGINT — 외래 키 → USERS.USERS_ID — NOT NULL
  • ROOM_ID (Key3) — BIGINT — 외래 키 → ROOM.ROOM_ID — NOT NULL
  • CHECK_IN (Field) — VARCHAR
  • CHECK_OUT (Field2) — VARCHAR

COMMENT (Untitled3)

  • COMMENT_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • WRITER (Field) — VARCHAR
  • CONTENTS (Field2) — VARCHAR
  • ROOM_ID (Key2) — BIGINT — 외래 키 → ROOM.ROOM_ID — NOT NULL
  • CREATED_AT (Field3) — DATE
  • MODIFY_AT (Field4) — DATE

LIKE_ROOM (Untitled4)

  • LIKE_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • USER_ID (Key2) — BIGINT — 외래 키 → USERS.USERS_ID — NOT NULL
  • ROOM_ID (Key3) — BIGINT — 외래 키 → ROOM.ROOM_ID — NOT NULL
  • Field

ROOM (Untitled2)

  • ROOM_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • TITLE (Field) — VARCHAR
  • CONTENTS (Field2) — VARCHAR
  • PRICE (Field4) — BIGINT
  • EXTRA_PRICE (Field5) — BIGINT
  • IMG (Field6) — VARCHAR
  • LOCATION (Field7) — VARCHAR
  • HEADE_DEFAULT (Field8) — INT
  • HEADE_MAX (Field9) — INT
  • LIKE_COUNT (Field10) — INT
  • USER_ID (Key2) — BIGINT — 외래 키 → USERS.USERS_ID — NOT NULL

TAG (Untitled5)

  • TAG_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • CONTENT (Field) — VARCHAR
  • ROOM_ID (Key2) — BIGINT — 외래 키 → ROOM.ROOM_ID — NOT NULL

USERS (Untitled)

  • USERS_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • EMAIL (Field2) — VARCHAR
  • PASSWORD (Field3) — VARCHAR
  • NICKNAME (Field4) — VARCHAR
  • USER_ROLE (Field5) — VARCHAR
  • KAKAO_ID (Field) — BIGINT