KURLY

Tables (10)

Authority (authority)

  • 권한 이름 (authority_name) — NOTNULL — Primary key — NOT NULL

Manager (manager)

  • 관리자ID (id) — NOTNULL — Primary key — NOT NULL
  • 사번 (bnum) — NOTNULL
  • 이름 (name) — NOTNULL
  • 비밀번호 (pw) — NOTNULL
  • 근무시간 (workTime) — NOTNULL
  • 근무지 (workPlace) — NOTNULL
  • 근무형식 (workType) — NOTNULL
  • 근무 날짜 (workDay) — NOTNULL

Manager_authority (user_authority)

  • 관리자ID (id) — NOTNULL — Foreign key → Manager.관리자ID — NOT NULL
  • 권한 이름 (authority_name) — NOTNULL — Foreign key → Authority.권한 이름 — NOT NULL

Notice (notice)

  • 공지사항ID (id) — NOTNULL — Primary key — NOT NULL
  • 제목 (title) — NOTNULL
  • 글내용 (text) — NOTNULL
  • 작성시간 (date) — NULL

Record (record)

  • 기록ID (id) — NOTNULL — Primary key — NOT NULL
  • 근무자ID (idx) — NOTNULL — Foreign key → Worker.근무자ID — NOT NULL
  • 출근 (start) — NULL — NOT NULL
  • 퇴근 (end) — NULL
  • 근무지 (workPlace) — NOTNULL
  • 근무 형식 (workType) — NOTNULL
  • 업무 횟수 (wcnt) — NOTNULL
  • 근무 태도 (wscore) — NOTNULL
  • 이름 (name) — NOTNULL

Worker (worker)

  • 근무자ID (id) — NOTNULL — Primary key — NOT NULL
  • 아이디 (userId) — NOTNULL — Primary key
  • 이름 (name) — NOTNULL
  • 전화번호 (pnum) — NOTNULL
  • 비밀번호 (pw) — NOTNULL
  • 성별 (gender) — NOTNULL
  • 주민등록번호 (hnum) — NOTNULL

Worker_list (workerlist)

  • 근무자ID (id) — NOTNULL — Foreign key → Worker.근무자ID — NOT NULL
  • 아이디 (userId) — NOTNULL — Foreign key → Worker.아이디
  • 근무지 (workPlace) — NULL
  • 근무시간 (workTime) — NULL
  • 근무 형식 (workType) — NULL
  • 근무 날짜 (workDay) — NULL
  • 계약여부 (con) — NOTNULL
  • 교육여부 (edu) — NOTNULL
  • 근무 배치 (arrangement) — NOTNULL
  • 근무 태도 (wscore) — NOTNULL
  • 업무 횟수 (wcnt) — NOTNULL

authority_worker

  • 권한 이름 (authority_name) — NOTNULL — Primary key — NOT NULL

workerToken

  • 토큰 (token) — NOTNULL — Primary key — NOT NULL
  • 생성시간 (createAt) — NULL

worker_authority

  • 근무자ID (id) — NOTNULL — Foreign key → Worker.근무자ID — NOT NULL
  • 권한 이름 (authority_name) — NOTNULL — Foreign key → authority_worker.권한 이름 — NOT NULL
  • 아이디 (userId) — NOTNULL — Foreign key → Worker.아이디