Probono
Tables (9)
Announcement
- announcement_id — VARHCAR(255) — Primary key — NOT NULL
- announcement_title — VARHCAR(255)
- announcement_content — VARHCAR(255)
- announcement_author — VARHCAR(255)
- announcement_date — VARHCAR(255)
Chat
- Chatroom_id — VARCHAR(255) — Foreign key → Chatroom.Chatroom_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Chatroom.member_id — NOT NULL
- Chat
Chatroom (Member_Chatroom)
- Chatroom_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
Member
- member_id — VARCHAR(255) — Primary key — NOT NULL
- member_name — VARCHAR(255)
- member_email — VARCHAR(255)
- member_password — VARCHAR(255)
- member_schoolCode — VARCHAR(255)
- member_nationality — VARCHAR(255)
PersonalizedLearning
- PersonalizedLearningList_id — VARHCAR(255) — Foreign key → PersonalizedLearningList.PersonalizedLearningList_id — NOT NULL
- schedule_id — VARCHAR(255) — Foreign key → PersonalizedLearningList.schedule_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → PersonalizedLearningList.member_id — NOT NULL
- content — VARHCAR(255)
PersonalizedLearningList
- PersonalizedLearningList_id — VARHCAR(255) — Primary key — NOT NULL
- schedule_id — VARCHAR(255) — Foreign key → Schedule.schedule_id — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Schedule.member_id — NOT NULL
QnA
- post_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- post_title — VARCHAR(255)
- post_contents — VARCHAR(255)
- post_date — VARCHAR(255)
Schedule
- schedule_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- content — VARCHAR(255)
- endTime — VARCHAR(255)
Timetable
- timetable_id — VARHCAR(255) — Primary key — NOT NULL
- member_id — VARCHAR(255) — Foreign key → Member.member_id — NOT NULL
- content — VARHCAR(255)