캘린더
테이블 (4)
board (게시판)
- id (key) — bigint — 기본 키 — NOT NULL
- category_id (Key) — bigint — 외래 키 → board_category.id — NOT NULL
- owner_id (Field) — bigint
- writer_id (Field2) — bigint
- is_creator (Field3) — tinyint
- is_blind (Field4) — tinyint
- title (Field6) — varchar
- content (Field7) — varchar
- video_url (Field8) — varchar
- video_metadata (Field9) — varchar
- like_count (Field10) — int
- report_count (Field11) — int
- reply_count (Field12) — int
- pinned_at (Field13) — timestamp
- created_at (Field14) — timestamp
- updated_at (Field15) — timestamp
- deleted_at (Field16) — timestamp
board_calendar (캘린더 추가정보)
- id (Key) — unsigned bigint — 기본 키 — NOT NULL
- board_id (key) — unsigned bigint — 외래 키 → board.id — NOT NULL
- start_at (Field2) — timestamp
- end_at (Field3) — timestamp
- type (Field) — varchar
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
- deleted_at (Field6) — timestamp
board_category (게시판 카테고리)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar
- type (Field2) — varchar
- owner_id (Field3) — bigint
- is_allowed (Field4) — tinyint
- is_hidden (Field5) — tinyint
- order (Field6) — int
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp
- deleted_at (Field9) — timestamp
앱 버전정보 (app_version)
- id (Key) — 기본 키 — NOT NULL