mazeltov

Tables (9)

anonymous_forum (익명게시판)

  • id (Key) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)

attendance (출퇴근)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • id (Key3) — Foreign key → user.authority_id — NOT NULL
  • clock_time (출 퇴근 날짜) — datetime
  • ip — varchar(20)
  • location (위치) — varchar(200)
  • memo (메모) — varchar(200)
  • device (출근디바이스) — varchar(10)
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime

authority (권한)

  • id (Key) — Primary key — NOT NULL
  • type (권한 타입) — varchar(10)

organization (조직도)

  • id (Key) — Primary key — NOT NULL
  • parents_id (부모id) — Foreign key → organization.id — NOT NULL
  • depth (깊이) — int
  • name (조직이름) — varchar(20)
  • use_yn (사용여부) — tinyint

organization_work_type (조직 출퇴근 유형)

  • id (Key) — Primary key — NOT NULL
  • work_type_id (Key2) — Foreign key → work_type.id — NOT NULL
  • organization_id (Key3) — Foreign key → organization.id — NOT NULL

user (유저)

  • id (Key) — Primary key — NOT NULL
  • organization_id (Key2) — Foreign key → organization.id — NOT NULL
  • authority_id (Key3) — Foreign key → authority.id — NOT NULL
  • email (이메일) — varchar(100)
  • birth (생년월일) — char(6)
  • phone (휴대폰 번호) — char(11)
  • status (유저 상태) — varchar(10)
  • position (직책) — varchar(10)
  • start_work (입사일) — date
  • end_work (퇴사일) — date
  • address (주소) — varchar(200)
  • created_at (생성일) — datetime
  • upated_at (수정일) — datetime

user_vacation (연차)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • count (개수) — double
  • expiry_date (만료일) — date
  • type (연차 종류) — varchar(10)
  • paid (유급 여부) — tinyint
  • remain (잔여일) — double
  • used_yn (사용완료 여부) — tinyint
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime

user_vacation_log (연차 로그)

  • id (Key) — Primary key — NOT NULL
  • user_vacation_id (Key2) — Foreign key → user_vacation.id — NOT NULL
  • status (연차 상태) — varchar(10)
  • type (타입) — varchar(10)
  • date (날짜) — datetime
  • created_at (생성일) — datetime
  • updated_at (수정일) — datetime

work_type (출퇴근 유형)

  • id (Key) — Primary key — NOT NULL
  • name (이름) — varchar(20)