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)