CMC-Dice
Tables (10)
Announcements (지원 공고)
- id — Primary key — NOT NULL
- 관리자_ID (owner_id) — Foreign key → Users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
ApplicationSupport (지원)
- id — Primary key — NOT NULL
- 유저_ID (guest_id) — Foreign key → Users.id — NOT NULL
- 공고_ID (announcement_id) — Foreign key → Announcements.id — NOT NULL
- status — ENUM('pending', 'accepted', 'rejected')
- message — TEXT
- created_at — DATETIME
FavoriteAnnouncements (찜 공고)
- id — Primary key — NOT NULL
- 유저_ID (user_id) — Foreign key → Users.id — NOT NULL
- 공고_ID (announcement_id) — Foreign key → Announcements.id — NOT NULL
- created_at — DATETIME
FavoriteSpaces (찜 공간)
- id — Primary key — NOT NULL
- 유저_ID (user_id) — Foreign key → Users.id — NOT NULL
- 공간_ID (space_id) — Foreign key → Spaces.id — NOT NULL
- created_at — DATETIME
Message
- idi (id) — Primary key — NOT NULL
- sender_id — BIGINT — NOT NULL
- receiver_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- read_status — BOOLEAN
- created_at — DATETIME
Reservations (공간 예약)
- id — Primary key — NOT NULL
- 유저_ID (guest_id) — Foreign key → Users.id — NOT NULL
- 공간_ID (space_id) — Foreign key → Spaces.id — NOT NULL
- reservation_date — DATETIME — NOT NULL
- message — TEXT
- created_at — DATETIME
- status — ENUM('pending', 'confirmed', 'canceled')
SpaceTag (공간태그)
- id — Primary key — NOT NULL
- 태그_ID (tag_id) — Foreign key → Tag.id — NOT NULL
- 공간_ID (space_id) — Foreign key → Spaces.id — NOT NULL
Spaces (공간)
- id — Primary key — NOT NULL
- 관리자 (owner_id) — Foreign key → Users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- created_at — DATETIME
Tag (태그)
- id — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
Users (유저)
- id — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('GUEST', 'ADMIN')
- created_at — DATETIME