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)