EzenUniv
Tables (11)
File
- fno — int — Primary key — NOT NULL
- frealnm — varchar(255) — NOT NULL
- foriginnm — varchar(255) — NOT NULL
- frdate — date — NOT NULL
administer
- ano — int — Primary key — NOT NULL
- aid — varchar(20) — NOT NULL
- apw — varchar(255) — NOT NULL
- ardate — date — NOT NULL
- amanage — tinyint — NOT NULL
- adelyn — tinyint — NOT NULL
attendment
- attendno — int — Primary key — NOT NULL
- attendrdate — varchar(10)
- attendyn — tinyint
- cno — int — Foreign key → course.cno — NOT NULL
board
- bno — int — Primary key — NOT NULL
- btitle — varchar(50) — NOT NULL
- bcontent — text — NOT NULL
- brdate — date — NOT NULL
- bhit — int — NOT NULL
- bdelyn — tinyint — NOT NULL
- ano — int — NOT NULL
- ano (ano2) — int — Foreign key → administer.ano — NOT NULL
boardBridgeFile
- bbfno — int — Primary key — NOT NULL
- fno — int — Foreign key → File.fno — NOT NULL
- bno — int — Foreign key → board.bno — NOT NULL
course
- cno — int — Primary key — NOT NULL
- cyn — tinyint — NOT NULL
- cgrade — varchar(4)
- cgradeupdater — varchar(20)
- cdelyn — tinyint — NOT NULL
- lno — int — Foreign key → lecture.lno — NOT NULL
- sno — int — Foreign key → student.sno — NOT NULL
lecture
- lno — int — Primary key — NOT NULL
- lname — varchar(40) — NOT NULL
- lyear — varchar(10) — NOT NULL
- lsemester — tinyint — NOT NULL
- lcredit — tinyint — NOT NULL
- ltime — tinyint — NOT NULL
- lroom — varchar(10) — NOT NULL
- lmaxpeople — varchar(5) — NOT NULL
- lintro — text — NOT NULL
- lfocus — text — NOT NULL
- lstatus — tinyint — NOT NULL
- lschedule — json
- pno — int — Foreign key → professor.pno — NOT NULL
profBridgeFile
- pbfno — int — Primary key — NOT NULL
- pno — int — Foreign key → professor.pno — NOT NULL
- fno — int — Foreign key → File.fno — NOT NULL
professor
- pno — int — Primary key — NOT NULL
- pid — varchar(20) — NOT NULL
- ppw — varchar(255) — NOT NULL
- pname — varchar(20) — NOT NULL
- pregNo1 — char(6) — NOT NULL
- pregNo2 — varchar(255) — NOT NULL
- pbirth — varchar(10) — NOT NULL
- pgender — varchar(2) — NOT NULL
- pemail — varchar(45) — NOT NULL
- pphone — varchar(20) — NOT NULL
- pcall — varchar(20)
- paddr — varchar(255) — NOT NULL
- pzipCode — varchar(10)
- prdate — date — NOT NULL
- pposition — varchar(20) — NOT NULL
- puniv — varchar(40) — NOT NULL
- pfaculty — varchar(40) — NOT NULL
- pmajor — varchar(40) — NOT NULL
- pdegree — varchar(40) — NOT NULL
- plab — varchar(40) — NOT NULL
- pappointDate — varchar(10) — NOT NULL
- pdelyn — tinyint — NOT NULL
student
- sno — int — Primary key — NOT NULL
- sid — varchar(20) — NOT NULL
- spw — varchar(255) — NOT NULL
- sname — varchar(20) — NOT NULL
- sregNo1 — char(6) — NOT NULL
- sregNo2 — varchar(255) — NOT NULL
- sbirth — varchar(10) — NOT NULL
- sgender — varchar(2) — NOT NULL
- semail — varchar(45) — NOT NULL
- sphone — varchar(20) — NOT NULL
- scall — varchar(20)
- saddr — varchar(255) — NOT NULL
- szipCode — varchar(10)
- srdate — date — NOT NULL
- sstatus — tinyint — NOT NULL
- suniv — varchar(40) — NOT NULL
- sfaculty — varchar(40) — NOT NULL
- smajor — varchar(40) — NOT NULL
- sgrade — tinyint — NOT NULL
- srank — int — NOT NULL
- scomeDate — varchar(10) — NOT NULL
- soutDate — varchar(10)
- scompletionDate — varchar(10)
- sgradDate — varchar(10)
- smaxgrade — tinyint — NOT NULL
- sdelyn — tinyint — NOT NULL
studentBridgeFile
- sbfno — int — Primary key — NOT NULL
- fno — int — Foreign key → File.fno — NOT NULL
- sno — int — Foreign key → student.sno — NOT NULL