메모

테이블 (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