클론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