게시판
okky erd
테이블 (3)
content (board)
- id — bigint(20) — 기본 키 — NOT NULL
- id (user_id) — bigint(20) — 외래 키 → user.id — NOT NULL
- a_nick_name (username) — varchar(255)
- Field2 (title) — varchar(255) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- selected — bit(1) — NOT NULL
- text — longtext — NOT NULL
- Field (view_count) — int(11) — NOT NULL
file
- id — bigint(20) — 기본 키 — NOT NULL
- id (board_id) — bigint(20) — 외래 키 → content.id — NOT NULL
- version — bigint(20) — NOT NULL
- attach_type — varchar(255) — NOT NULL
- byte_size — int(11) — NOT NULL
- height — int(11) — NOT NULL
- name — varchar(255) — NOT NULL
- org_name — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- width — int(11) — NOT NULL
user
- id — bigint(20) — 기본 키 — NOT NULL
- version — bigint(20) — NOT NULL
- account_expired — bit(1) — NOT NULL
- date_created — datetime — NOT NULL
- enabled — bit(1) — NOT NULL
- last_updated — datetime — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(15) — NOT NULL
- Field (managed_user) — bit(1) — NOT NULL