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)