Club 도메인 설계

club 도메인 설계

테이블 (6)

Category (categories)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • description (Field2) — varchar(50)
  • created_at (Field3) — datetime

Club (clubs)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • category_id (FK) — bigint — 외래 키 → Category.id — NOT NULL
  • name (Field) — varchar(20)
  • image_url (Field2) — varchar(500)
  • address (Field3) — varchar(50)
  • university (Field4) — varchar(20)
  • description (Field6) — varchar(500)
  • created_at (Field7) — datetime
  • updated_at (Field8) — datetime

ClubJoinState (club_join_states)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (FK) — bigint — 외래 키 → User.id — NOT NULL
  • club_id (FK2) — bigint — 외래 키 → Club.id — NOT NULL
  • join_state (Field) — int
  • is_used (Field2) — boolean
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

Comment (comments)

  • Key — 기본 키 — NOT NULL
  • post_id (FK) — bigint — 외래 키 → Post.id — NOT NULL
  • user_id (FK2) — bigint — 외래 키 → User.id — NOT NULL
  • contents (Field) — varchar(500)
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

Post (posts)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (FK) — bigint — 외래 키 → User.id — NOT NULL
  • club_id (FK2) — bigint — 외래 키 → Club.id — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — varchar(500)
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

User (users)

  • id (key) — bigint — 기본 키 — NOT NULL
  • email (Field) — varchar(50) — NOT NULL
  • password (Field2) — varchar(80) — NOT NULL
  • name (Field3) — varchar(10)
  • nickname (Field4) — varchar(20) — NOT NULL
  • university (Field5) — varchar(20)
  • profile_url (Field6) — varchar(500)
  • introduction (Field7) — varchar(100)
  • created_at (Field8) — datetime
  • updated_at (Field9) — datetime