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