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