KDT_CLUB

Tables (7)

Activity (-)

  • activity_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content: (Field2)
  • photo (Field3)
  • activity_date (Field4)
  • text (Field5)
  • club_id (Key2) — Foreign key → Club.club_id — NOT NULL

Application (CopyOfCopyOfUntitled3)

  • application_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • motivation (Field3)
  • status (Field4)
  • club_id (Key2) — Foreign key → Club.club_id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL

Club (CopyOfCopyOfUntitled)

  • club_id (Key) — Primary key — NOT NULL
  • name (Field)
  • president (Field2)
  • introduction (Field3)
  • founded_date (Field4)

Club_Membership (Untitled2)

  • club_id (Key) — Foreign key → Club.club_id — NOT NULL
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL

Comment (CopyOfCopyOfUntitled2)

  • comment_id (Key) — Primary key — NOT NULL
  • content (Field2)
  • department (Field3)
  • post_id (Field4)
  • member_id (Key4) — Foreign key → Member.member_id — NOT NULL
  • post_id (Key3) — Foreign key → Post.post_id — NOT NULL

Member (CopyOfUntitled)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • department (Field3)
  • password (Field4)
  • club_id (Key3) — Foreign key → Club.club_id — NOT NULL

Post (Untitled)

  • post_id (Key) — Primary key — NOT NULL
  • title (Field)
  • content: (Field2)
  • photo (Field3)
  • created_by (Field4)
  • created_at (Field5)
  • type (Field6)
  • is_president_post (Field7)
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL