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