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