poc_fixed

Tables (6)

attachments

  • attachment_id — INT — Primary key — NOT NULL — 파일 크기 (bytes)
  • target_type — VARCHAR(100) — NOT NULL — 체크섬 (무결성 검증)
  • target_id — INT — NOT NULL — 파일 확장자
  • file_name — VARCHAR(255) — NOT NULL — 정렬 순서
  • file_path — VARCHAR(500) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100)
  • updated_by — VARCHAR(100)

board_members

  • workspace_id — INT — Foreign key → workspaces.workspace_id — NOT NULL — PK
  • board_id — INT — Foreign key → boards.board_id — NOT NULL — 대상 엔티티 타입 (polymorphic)
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 대상 엔티티 ID (polymorphic)
  • last_edited_at — TIMESTAMP — 파일명
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100)
  • updated_by — VARCHAR(100)

boards

  • board_id — INT — Primary key — NOT NULL — 보드 이름
  • workspace_id — INT — Foreign key → workspaces.workspace_id — NOT NULL — 신발 카테고리
  • owner_id — INT — Foreign key → users.user_id — NOT NULL — 아웃라인
  • name — VARCHAR(255) — NOT NULL — 테마
  • shoe_category — VARCHAR(100) — 썸네일 URL
  • outline — VARCHAR(255) — PK/FK1 → workspaces.workspace_id
  • theme — VARCHAR(100) — PK/FK2 → boards.board_id
  • thumbnail — VARCHAR(500) — PK/FK3 → users.user_id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100)
  • updated_by — VARCHAR(100)

users

  • user_id — INT — Primary key — NOT NULL — PK
  • email — VARCHAR(255) — NOT NULL — 로그인 이메일
  • password — VARCHAR(255) — 비밀번호 해시
  • name — VARCHAR(100) — NOT NULL — 사용자 이름
  • avatar — VARCHAR(500) — 프로필 이미지 URL
  • organization — VARCHAR(255) — 소속 조직
  • last_login_at — TIMESTAMP — 마지막 로그인 시각
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — 생성자
  • updated_by — VARCHAR(100) — 수정자

workspace_members

  • workspace_id — INT — Foreign key → workspaces.workspace_id — NOT NULL — 역할 (owner/admin/member/viewer)
  • user_id — INT — Foreign key → users.user_id — NOT NULL — PK
  • role — VARCHAR(50) — NOT NULL — FK → workspaces.workspace_id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100)
  • updated_by — VARCHAR(100)

workspaces

  • workspace_id — INT — Primary key — NOT NULL — FK → users.user_id
  • owner_id — INT — Foreign key → users.user_id — NOT NULL — 워크스페이스 이름
  • name — VARCHAR(255) — NOT NULL — 설명
  • description — VARCHAR(500) — 썸네일 URL
  • thumbnail — VARCHAR(500) — PK/FK1 → workspaces.workspace_id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100)
  • updated_by — VARCHAR(100)