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