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