크루관리 시스템
테이블 (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