riset
Tables (14)
BOARD (Untitled12)
- BOARD_NO — Primary key — NOT NULL
- EMPLOYEE_NO
- TITLE
- CONTENT
BOARD_FILE (Untitled10)
- BOARD_FILE_ID — Primary key — NOT NULL
- BOARD_ID
- FILE_ID
COMMENT (Untitled13)
- REOLY_NO (REPLY_NO) — Primary key — NOT NULL
- BOARD_NO
- COMMENT
- EMPLOYEE_NO (EMPLOYYEE_NO)
COMMUTE (Untitled3)
- EMPLOYEE_NO — Primary key — NOT NULL
- START_DT
- END_DT
- STATUS
- WORK_HOURS
COMPANY (Untitled4)
- COMPANY_NO — Primary key — NOT NULL
- COMPANY_NAME
- COMPANY_ADDR
- COMPANY_TEL_NO
- ZIP_CODE
COMPANY_LOCATION (Untitled5)
- LOCATiON_NO (LOCATION_NO) — Primary key — NOT NULL
- COMPANY_NO
- LATITUDE
- LONGGITUDE (LONGITUDE)
- COMMENT
DEPARTMENT (Untitled9)
- DEPARTMENT_NO — Primary key — NOT NULL
- COMPANY_NO
- DEPARTMENT_NAME
EMPLOYEE (Untitled)
- EMPLOYEE_NO — Primary key — NOT NULL
- EMPLOYEE_ID
- PASSWORD
- NAME
- TEL_NO
- JOB_GRADE (JOB_GREADE)
- ADDRESS
- BIRTH
- DEPARTMENT_NO
- POSITION
- JOB_TITLE
FAVORITE (Untitled14)
- FAVORITE_ID — Primary key — NOT NULL
- BORAD_NO
- EMPLOYEE_NO
- ORDER
FILE (Untitled8)
- FILE_ID — Primary key — NOT NULL
- FILE_NAME
- FILE_PATH
- FILE_SiZE (FILE_SIZE)
- FIEL_TPYE (FILE_TYPE)
JOB_GRADE (Untitled2)
- GRADED_CODE (GRADE_CODE) — Primary key — NOT NULL
- GORADE
LEAVE (Untitled7)
- LEAVE_NO — Primary key — NOT NULL
- EMPLOYEE_NO
- START_DT
- END_DT
- TYPE
- STATUS
- COMMENT
MENU (Untitled6)
- MENU_ID — Primary key — NOT NULL
- MENU_NAME
- PARENT_ID
- DEPTH
- MENU_ORDER
- FILE_ID
- MENU_URL
SCHEDULE (Untitled11)
- SCHEDULE_NO — Primary key — NOT NULL
- EMPLOYEE_NO
- COMPANY_NO
- START_DT
- END_DT
- TITLE