게시판
테이블 (3)
account
- idx — SERIAL
- id — VARCHAR(20) — NOT NULL
- pw — VARCHAR(20) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- phonenumber — VARCHAR(15) — NOT NULL
- email — VARCHAR(24) — NOT NULL
- is_admin — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
comment
- idx — SERIAL
- post_idx — INT — NOT NULL
- account_idx — INT — NOT NULL
- content — VARCHAR(600) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP
post
- idx — SERIAL
- account_idx — INT — NOT NULL
- title — VARCHAR(300) — NOT NULL
- content — VARCHAR(3000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP