메모
테이블 (6)
MEMO
- MEMO_SEQ — BIGINT — 기본 키 — NOT NULL
MEMO_ATTACH_FILE
- MEMO_ATTACH_FILE_SEQ — BIGINT — 기본 키 — NOT NULL
- MEMO_SEQ — BIGINT — 외래 키 → MEMO.MEMO_SEQ — NOT NULL
- FILE_URL — VARCHAR(1000) — NOT NULL
- CREATED_AT — DATETIME(6) — NOT NULL
- CREATED_BY — BIGINT — NOT NULL
memo_attachments
- id — VARCHAR(36)
- memo_id — VARCHAR(36) — 외래 키 → memos.id — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- original_filename — VARCHAR(255)
- mime_type — VARCHAR(100)
- size_bytes — BIGINT
- created_at — TIMESTAMP
memo_types
- id — VARCHAR(36)
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- color — VARCHAR(30)
- sort_order — INT
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
memos
- id — VARCHAR(36)
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- memo_type_id — VARCHAR(36) — 외래 키 → memo_types.id
- memo_date — DATE
- assignee_user_id — VARCHAR(36) — 외래 키 → users.id
- title — VARCHAR(200)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — VARCHAR(36)
- name — VARCHAR(100)
- created_at — TIMESTAMP