파일 업로드 처리 & AI 활용 개발 과제

테이블 (4)

extension_policy

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • is_blocked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

extension_policy_audit_log

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • action — VARCHAR(10) — NOT NULL
  • changed_by_member_id — BIGINT — 외래 키 → member.id
  • changed_by_username — VARCHAR(50) — NOT NULL
  • changed_at — TIMESTAMPTZ — NOT NULL

member

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

uploaded_file

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • stored_filename — VARCHAR(255) — NOT NULL
  • extension — VARCHAR(20)
  • detected_mime — VARCHAR(100)
  • magic_byte_matched — BOOLEAN
  • size_bytes — BIGINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • reject_reason — VARCHAR(255)
  • uploaded_by_member_id — BIGINT — 외래 키 → member.id
  • uploaded_by_username — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ