파일 업로드 처리 & 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