캘린더

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