kosa-space
Tables (5)
course (교육과정)
- cno — NUMBER — Primary key — NOT NULL
- trno — NUMBER — Foreign key → trainingroom.trno — NOT NULL
- ecno — NUMBER — Foreign key → trainingroom.ecno — NOT NULL
- cname — VARCHAR
- ccode — VARCHAR(15)
- ctotalnum (ctotalnuim) — NUMBER
- cstartdate — TIMESTAMP
- cenddate — TIMESTAMP
- crequireddate — NUMBER
- ctrainingdate — VARCHAR
- cstatus — VARCHAR(30)
- ctrainingtime — VARCHAR(30)
- cprofessor — VARCHAR(15)
- cmanager — VARCHAR(15)
- ccreatedat — TIMESTAMP
- cupdatedat — TIMESTAMP
eduattach (교육관리 첨부파일)
- eano — NUMBER — Primary key — NOT NULL
- ecno — NUMBER — Foreign key → educenter.ecno — NOT NULL
- trno — NUMBER — Foreign key → course.trno — NOT NULL
- cno — NUMBER — Foreign key → trainingroom.trno — NOT NULL
- eaattach — BLOB
- eaattachoname — VARVHAR
- eaattachtype — VARCHAR
- eacreatedat — TIMESTAMP
- eaupdatedat — TIMESTAMP
educenter (교육장)
- ecno — NUMBER — Primary key — NOT NULL
- ecname — VARCHAR(30)
- ecaddress — VARCHAR(200)
- ecpostcode — VARCHAR(10)
- eccreatedat — TIMESTAMP
- ecupdatedat — TIMESTAMP
member (회원)
- mid — VARCHAR — Primary key — NOT NULL
- mpassword — VARCHAR(255)
- mname
- mphone — VARVHAR
- memail — VARCHAR
- mrole — VARCHAR
- menable
trainingroom (강의실)
- trno — NUMBER — Primary key — NOT NULL
- ecno — NUMBER — Foreign key → educenter.ecno — NOT NULL
- trname — VARCHAR(20)
- trcapacity — NUMBER
- trenable — CHAR(1)
- trcreatedat — TIMESTAMP
- trupdatedat — TIMESTAMP