Evaluation_v2
evaluation modeling...
Tables (20)
COMPANY (tbl_company)
- Key (cno) — number(10,0) — Primary key — NOT NULL
- Field4 (homepage) — varchar(100)
- Field3 (logoUuid)
- Field (logoUploadPath)
- Field2 (logoFileName)
- Field (status)
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
Question (Untitled)
- qno (Key) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
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
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
USER_SETTING_INFO (tbl_individual_info)
- Key (sno) — Primary key — NOT NULL
- Field (department1)
- Field2 (department2)
- Field3 (level)
- Field (division1) — varchar2(30) — NOT NULL
- Field2 (division2) — varchar2(30) — NOT NULL
- Key (uno) — Foreign key → User.Key — 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
User (tbl_user)
- Key (uno) — Primary key — NOT NULL
- Field (email)
- Field2 (password)
- Field3 (name)
- Field (role)
- Key (cno) — number(10,0) — Foreign key → COMPANY.Key — NOT NULL