과제

테이블 (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