team4_erd_uk

프리온보딩 팀4 erd

테이블 (5)

COMMENTS

  • PK (COMMENT_ID) — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • FK (USER_ID) — BIGINT — 외래 키 → USERS.PK — NOT NULL — AUTO_INCREMENT
  • FK (POST_ID) — BIGINT — 외래 키 → POSTS.PK — NOT NULL — AUTO_INCREMENT
  • Field (CONTENT) — TEXT — NOT NULL
  • Field (CREATED_DATE) — TIMESTAMP — NOT NULL
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP — NOT NULL

FRIENDS

  • PK (FRIEND_ID) — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • FK (FROM) — BIGINT — 외래 키 → USERS.PK — NOT NULL
  • FK (TO) — BIGINT — 외래 키 → USERS.PK — NOT NULL
  • Field (CREATED_DATE) — TIMESTAMP — NOT NULL
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP — NOT NULL

POSTS

  • PK (POST_ID) — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • FK (USER_ID) — BIGINT — 외래 키 → USERS.PK — NOT NULL
  • Field (TITLE) — VARCHAR(255) — NOT NULL
  • Field (CONTENT) — TEXT — NOT NULL
  • Field (LIKE) — BIGINT — NOT NULL
  • Field (VIEWS) — BIGINT — NOT NULL
  • Field (CREATED_DATE) — TIMESTAMP — NOT NULL
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP — NOT NULL

ROLES

  • PK (ROLE_ID) — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • FK (PARENT_ID) — BIGINT — 외래 키 → ROLES.PK — NOT NULL
  • Field (ROLE_NAME) — VARCHAR(255) — NOT NULL
  • Field (DESCRIPTION) — VARCHAR(255)
  • Field (CREATED_DATE) — TIMESTAMP — NOT NULL
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP — NOT NULL
  • Field (CREATED_BY) — VARCHAR(255) — NOT NULL
  • Field (LAST_MODIFIED_BY) — VARCHAR(255) — NOT NULL

USERS

  • PK (USER_ID) — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • FK (ROLE_ID) — BIGINT — 외래 키 → ROLES.PK — NOT NULL
  • Field (USERNAME) — VARCHAR(255) — NOT NULL
  • Field (NICKNAME) — VARCHAR(255) — NOT NULL
  • Field (PASSWORD) — VARCHAR(255) — NOT NULL
  • Field (CREATED_DATE) — TIMESTAMP — NOT NULL
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP — NOT NULL