면담기록부

테이블 (3)

d_Employees_Info

  • d_Ad_Id — varchar
  • d_Name — varchar — NOT NULL
  • d_Position — varchar
  • d_Job_grade — varchar — NOT NULL
  • d_Group — varchar
  • d_Division — varchar
  • d_Team — varchar
  • d_Hire_Date — date
  • d_Termination_Date — date
  • d_Create_Date — timestamp
  • d_Create_Ad_Id — varchar

d_Interview_Detail

  • d_Num — identity
  • d_Ad_Id — varchar
  • d_Position — varchar
  • d_Job_grade — varchar — NOT NULL
  • d_Group — varchar
  • d_Division — varchar
  • d_Team — varchar
  • d_Interviewer_Ad_Id — varchar
  • d_Interview_Status — int
  • d_Interview_Content — text — NOT NULL
  • d_Interview_Location — text — NOT NULL
  • d_Interview_Date — date
  • d_Interview_Issue — text
  • d_Interview_Secret — boolean
  • d_Create_Ad_Id — varchar
  • d_Update_Date — timestamp

d_Interview_Main

  • d_Ad_Id — varchar
  • d_Name — varchar — NOT NULL
  • d_Last_Interview_Date — date
  • d_Last_Status — int
  • d_Create_Date — timestamp
  • d_Create_Ad_Id — varchar
  • d_Update_Date — timestamp