advanced Web Project
테이블 (5)
게시물 (Post)
- Post_id (Key) — int — 기본 키 — NOT NULL
- Student ID (Key2) — int — 외래 키 → 회원.Student ID — NOT NULL
- BoardType (Field) — Enum
- Title (Field2) — String
- Content (Field3) — String
- Url (Field4) — String
동아리 (Club)
- Club_id (Key) — int — 기본 키 — NOT NULL
- Name (Field6)
- ClubType (Field) — Enum
- Request_student_ID (Field2) — User
- REquest_professor_ID (Field3) — User
- Status (Field4) — Enum
- Refuse_info (Field5) — String
동아리 상세정보 (ClubInfo)
- Club_id (Key2) — int — 외래 키 → 동아리.Club_id — NOT NULL
- History (Field4) — String
- Img (Field5) — Image
- MeetingTime (Field6) — String
- RequestForm (Field8) — File
동아리 인원 (Club Member)
- Club_id (Key) — int — 외래 키 → 동아리.Club_id — NOT NULL
- Student ID (Key2) — int — 외래 키 → 회원.Student ID — NOT NULL
- Condition (Field2) — Enum
- Rank (Field3) — Enum
회원 (Member)
- Student ID (Key) — int — 기본 키 — NOT NULL
- Name (Field) — String
- DateOfBirth (Field2) — int
- Gender (Field4) — Enum
- Department (Field3) — String
- PhoneNum (Field5) — int
- Email (Field6) — String
- Role (Field7) — Enum