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