db project
테이블 (4)
Copy Of Untitled (reply)
- Key (reply_id) — INT — 기본 키 — NOT NULL
- Key (post_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (author_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (importance_id) — INT — 외래 키 → 중요도.Key — NOT NULL
- Field (created_time) — datetime
- Field (updated_time) — datetime
- Field (content) — TEXT
- Field (view_count) — INT
- Field (help_count) — INT
Untitled (post)
- Key (post_id) — INT — 기본 키 — NOT NULL
- Key (author_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (importance_id) — INT — 외래 키 → 중요도.Key — NOT NULL
- Field (created_time) — datetime
- Field (updated_time) — datetime
- Field (content) — TEXT
- Field (title) — TEXT
- Field (view_count) — INT
- Field (help_count) — INT
Untitled (users)
- Key (user_id) — INT — 기본 키 — NOT NULL
- Field (username) — VARCHAR
- Field2 (password) — VARCHAR
- Field (name) — VARCHAR
- Field (type) — INT
- Field (birth) — VARCHAR
- Field (sex) — VARCHAR
- Field (address) — VARCHAR
- Field (phone) — VARCHAR
중요도 (importance)
- Key (importance_id) — INT — 기본 키 — NOT NULL
- Field (score) — INT
- Field2 (last_updated) — DateTime