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