크루관리 시스템

테이블 (8)

board

  • board_id — BIGINT
  • crew_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • type — ENUM('NORMAL','NOTICE')
  • created_at — DATETIME

calendar_event

  • event_id — BIGINT
  • crew_id — BIGINT — NOT NULL
  • post_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_notice — BOOLEAN
  • created_at — DATETIME

comment

  • comment_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME

crew

  • crew_id — BIGINT — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME

crew_member

  • crew_member_id — BIGINT
  • crew_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role_in_crew — ENUM('MEMBER','MANAGER')
  • joined_at — DATETIME

post

  • post_id — BIGINT
  • board_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

resource

  • resource_id — BIGINT
  • crew_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • url — VARCHAR(500)
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME

users

  • Key — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('USER','ADMIN')
  • created_at — DATETIME