TotalNotices

Tables (4)

College (University)

  • university_id — bigint — Primary key — NOT NULL
  • university_name — varchar(100)

Notice

  • notice_id — Bigint — Primary key — NOT NULL
  • title — varchar(255)
  • url — text
  • notice_date — varchar(50)
  • noticetype_id — bigint — Foreign key → Noticetype.noticetype_id — NOT NULL
  • university_id — bigint — Foreign key → College.university_id — NOT NULL

Noticetype (Notice_type)

  • noticetype_id — bigint — Primary key — NOT NULL
  • Noticetype_name (noticetype_name) — varchar(20)

User

  • user_id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • email — varchar(50)
  • password — varchar(16)
  • university_id — int — Foreign key → College.university_id — NOT NULL