과제
테이블 (4)
COMMENT (Comments)
- PK (COMMENT_ID) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- FK (POST_ID) — BIGINT — 외래 키 → POST.PK — NOT NULL
- FK (USER_ID) — BIGINT — 외래 키 → POST.FK — NOT NULL
- Field (COMMENT_DESC) — VARCHAR(255)
- Field (CREATED_AT) — DATETIME
- Field (UPDATED_AT) — DATETIME
POST (Posts)
- PK (POST_ID) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- FK (USER_ID) — BIGINT — 외래 키 → User.PK — NOT NULL
- Field (POST_DESC) — VARCHAR(255)
- Field (POST_COMMENT) — BIGINT
- Field (POST_LIKE) — BIGINT
- Field (POST_TYPE) — TINYINT(1)
- Field (CREATED_AT) — DATETIME
- Field (UPDATED_AT) — DATETIME
STUDY (study)
- Key (STUDY_KEY) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- PK (USER_ID) — BIGINT — 외래 키 → User.PK — NOT NULL
- Field (STUDY_USER_CNT) — INT
- Field (STUDY_USERS) — BIGINT
- Field (STUDY_STATUS) — VARCHAR
- Field (CREATED_AT) — DATETIME
- Field (UPDATED_AT) — DATETIME
User (Users)
- PK (USER_ID) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- Field (USER_NUMBER) — INT
- Field (USER_PASSWORD) — VARCHAR(255)
- Field (USER_NICKNAME) — VARCHAR(255)
- Field (CREATED_AT) — DATETIME
- Field (UPDATED_AT) — DATETIME