group chat
Tables (4)
Subject
- subject_ID — VARCHAR(20) — Primary key — NOT NULL
- Subject_name — VARCHAR(20)
- credit — INT(2)
- classification — VARCHAR(10)
- capacity — INT(3)
- User_ID — INT(10) — Foreign key → User.User_ID — NOT NULL
User
- User_ID — INT(10) — Primary key — NOT NULL
- password — VARCHAR(15)
- username — VARCHAR(5)
- email — VARCHAR(20)
chat_gruop
- subject_ID — VARCHAR(20) — Foreign key → Subject.subject_ID — NOT NULL
- gruop_ID (group_ID) — VARCHAR(10)
- message — VARCHAR(100)
chat_join
- User_ID — INT(10) — Foreign key → User.User_ID — NOT NULL
- subject_ID — VARCHAR(20) — Foreign key → chat_gruop.subject_ID — NOT NULL
- group_ID — VARCHAR(10)