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