면담기록부
테이블 (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