Evaluation
evaluation modeling...
Tables (18)
COMPANY (tbl_company)
- Key (cno) — number(10,0) — Primary key — NOT NULL
- Field (id) — varchar(30)
- Field2 (password) — varchar2(255)
- Field (name) — varchar2(30)
- Field4 (homepage) — varchar(100)
- Field3 (logoUuid)
- Field (logoUploadPath)
- Field2 (logoFileName)
- Field5 (writeId) — varchar2(30)
- Field6 (writeDate) — date
- Field7 (updateId) — varchar2(30)
- Field (updateDate) — date
Info360 (tbl_360_info)
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field (title) — varchar2(100) — NOT NULL
- Field (content) — varchar2(200)
- Field (replyCode) — NOT NULL
- Field (status) — NOT NULL
- Field2 (startDate) — date — NOT NULL
- Field3 (endDate) — date — NOT NULL
- Field (writeID) — varchar2(30) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field3 (updateID) — varchar2(30) — NOT NULL
- Field4 (updateDate) — date — NOT NULL
InfoMbo (tbl_mbo_info)
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field (title) — varchar2(100) — NOT NULL
- Field2 (content) — varchar2(200)
- Field4 (status) — NOT NULL
- Field5 (startDate) — date — NOT NULL
- Field6 (endDate) — date — NOT NULL
- Field (writeID) — varchar2(30) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field3 (updateID) — varchar2(30) — NOT NULL
- Field4 (updateDate) — date — NOT NULL
ListMbo (tbl_mbo_list)
- Key (lno) — number(10,0) — Primary key — NOT NULL
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field (evaluated) — varchar2(30) — NOT NULL
- Field3 (final) — NOT NULL
- Field4 (content) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field4 (updateDate) — date — NOT NULL
Question360 (tbl_360_question)
- Key (qno) — number(10,0) — Primary key — NOT NULL
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field2 (division1) — varchar2(30) — NOT NULL
- Field3 (division2) — varchar2(30) — NOT NULL
- Field (question_idx) — INT — NOT NULL
- Field4 (category) — varchar2(30) — NOT NULL
- Field5 (question) — varchar2(200) — NOT NULL
- Field6 (writeID) — varchar2(30) — NOT NULL
- Field (writeDate) — date — NOT NULL
- Field2 (updateID) — varchar2(30) — NOT NULL
- Field3 (updateDate) — date — NOT NULL
REPLY_CODE (tbl_contents)
- Key (cno) — Primary key — NOT NULL
- Key (bno) — Foreign key → REPLY_TITLE.Key — NOT NULL
- Field (contents) — NOT NULL
- Field2 (sort) — NOT NULL
- Field (writeID) — varchar2(30) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field3 (updateID) — varchar2(30) — NOT NULL
- Field4 (updateDate) — date — NOT NULL
REPLY_TITLE (tbl_book)
- Key (bno) — Primary key — NOT NULL
- Field (title)
- Field (writeID) — varchar2(30) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field3 (updateID) — varchar2(30) — NOT NULL
- Field4 (updateDATE) — date — NOT NULL
Relation360 (tbl_360_relation)
- Key (rno) — number(10,0) — Primary key — NOT NULL
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field (evaluated) — varchar2(30) — NOT NULL
- Field2 (evaluator) — varchar2(30) — NOT NULL
- Field3 (relation) — NOT NULL
- Field5 (answerMap)
- Field (commentMap)
- Field4 (finish)
- Field (evalDate) — date
RelationMbo (tbl_mbo_relation)
- Key (rno) — number(10,0) — Primary key — NOT NULL
- Key (tno) — number(10,0) — Foreign key → TURN.Key — NOT NULL
- Field (evaluated) — varchar2(30) — NOT NULL
- Field2 (evaluator) — varchar2(30) — NOT NULL
- Field3 (relation) — NOT NULL
- Field4 (evaluation)
- Field (finish)
- Field (evalDate) — date
STAFF (tbl_staff)
- Key (sno) — Primary key — NOT NULL
- Key (cno) — Foreign key → COMPANY.Key — NOT NULL
- Field (email)
- Field (staffID) — varchar2(30) — NOT NULL
- Field2 (password) — varchar2(255) — NOT NULL
- Field3 (name) — varchar2(30) — NOT NULL
- Field4 (department1) — varchar2(30) — NOT NULL
- Field5 (department2) — varchar2(30) — NOT NULL
- Field6 (level) — varchar2(30) — NOT NULL
- Field (division1) — varchar2(30) — NOT NULL
- Field2 (division2) — varchar2(30) — NOT NULL
- Field3 (writeID) — varchar2(30) — NOT NULL
- Field4 (writeDate) — date — NOT NULL
- Field5 (updateID) — varchar2(30) — NOT NULL
- Field (updateDate) — date — NOT NULL
TURN (tbl_turn)
- Key (tno) — Primary key — NOT NULL
- Key (cno) — Foreign key → COMPANY.Key — NOT NULL
- Field2 (title) — varchar2(100) — NOT NULL
- Field (surveyType) — NOT NULL
- Field (writeID) — varchar2(30) — NOT NULL
- Field2 (writeDate) — date — NOT NULL
- Field3 (updateID) — varchar2(30) — NOT NULL
- Field4 (updateDate) — date — NOT NULL
Untitled (tbl_logo)
- Key (cno) — number(10,0) — Foreign key → COMPANY.Key — NOT NULL
- Field
Untitled (tbl_Department)
- Key (dno) — Primary key — NOT NULL
- Key (cno) — number(10,0) — Foreign key → COMPANY.Key — NOT NULL
- Field2 (department1)
- Field3 (department2)
Untitled (tbl_Level)
- Key (lno) — Primary key — NOT NULL
- Key (cno) — number(10,0) — Foreign key → COMPANY.Key — NOT NULL
- Field (item)
Untitled (tbl_division)
- Key (dno) — Primary key — NOT NULL
- Field (division1)
- Field2 (division2)
- Key (cno) — number(10,0) — Foreign key → COMPANY.Key — NOT NULL
Untitled (tbl_Leader)
- Key (lno) — Primary key — NOT NULL
- Field2 (sno)
- Field3 (dno)
- Field4 (title)
- Field (content)
- Key (dno2) — Foreign key → Untitled.Key — NOT NULL
Untitled (tbl_Object)
- Key (mno) — Primary key — NOT NULL
- Field (sno)
- Key (tno) — Foreign key → TURN.Key — NOT NULL
- Field (title)
- Field2 (comment)
- Field (ratio)
- Field (difficulty)
- Field (final)
Untitled (tbl_Object_Reply)
- Key (rno) — Primary key — NOT NULL
- Field (comment)
- Key (mno) — Foreign key → Untitled.Key — NOT NULL