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