tech-log-erd
Tables (6)
ACCESS_LOGS
- access_log_id — BIGSERIAL — Primary key — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- access_ip — VARCHAR(45) — NOT NULL
- request_uri — VARCHAR(500) — NOT NULL
- method — VARCHAR(10) — NOT NULL
- status_code — INT — NOT NULL
BOARDS
- board_id — BIGSERIAL — Primary key — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- views — BIGINT — NOT NULL
BOARD_CATEGORY
- board_category_id — BIGSERIAL — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
- category_id — BIGINT — Foreign key → CATEGORIES.category_id — NOT NULL
CATEGORIES
- category_id — BIGSERIAL — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
COMMENTS
- comment_id — BIGSERIAL — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- content — VARCHAR(500) — NOT NULL
- github_name — VARCHAR(100) — NOT NULL
- access_ip — VARCHAR(45) — NOT NULL
IMAGES
- image_id — BIGSERIAL — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
- storage_type — VARCHAR(20) — NOT NULL
- file_key — TEXT — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- image_order — INT — NOT NULL
- is_thumbnail — BOOLEAN — NOT NULL