kp
Tables (15)
Admin (admins)
- id — Primary key — NOT NULL
- user+id (user_id) — Foreign key → User.id — NOT NULL
- Field
AttendanceManagement (Untitled8)
- id (Key) — Primary key — NOT NULL
- branch_id (Key3) — Foreign key → Branche.id — NOT NULL
- user_info_id (Key2) — Foreign key → UserInfo.id — NOT NULL
- payroll_id (Key4) — Foreign key → Payroll.id — NOT NULL
- name (Field)
- affiliation (Field2)
- Field3
- gender (Field4)
- contact (Field5)
- pay (Field6)
- pay_type (Field7)
- scheduled_work_day (Field8)
- scheduled_start_time (Field9)
- scheduled_end_time (Field10)
- work_day (Field11)
- start_time (Field12)
- end_time (Field13)
- status (Field14)
Branche (Untitled3)
- id (Key) — Primary key — NOT NULL
- organization_id (id) — Foreign key → Organization.id — NOT NULL
- name (Field)
- operation_type (Field2)
- weekly_pay_date (Field3)
- monthly_pay_date (Field4)
FailedJob (Untitled5)
- id (Key) — Primary key — NOT NULL
- uuid (Field)
- connection (Field2)
- queue (Field3)
- payload (Field4)
- exception (Field5)
- Field6
Member (members)
- id — Primary key — NOT NULL
- user_id — Foreign key → User.id — NOT NULL
- Field
Organization (Untitled2)
- id — Primary key — NOT NULL
- name (Field)
Payroll (Untitled9)
- id (Key) — Primary key — NOT NULL
- branch_id (Key2) — Foreign key → Branche.id — NOT NULL
- user_info_id (Key3) — Foreign key → UserInfo.id — NOT NULL
- start_work_day (Field)
- end_work_day (Field2)
- total_pay (Field3)
- pay_status (Field4)
- pay_type (Field5)
- pay_day (Field6)
- working_hours (Field7)
PersonalAccessToken (Untitled6)
- id (Key) — Primary key — NOT NULL
- tokenable (Field)
- name (Field2)
- token (Field3)
- abilities (Field4)
- last_used_at (Field5)
- expires_at (Field6)
Role (roles)
- id — Primary key — NOT NULL
- 관리자
- 회원
Role (Untitled10)
- id (Key) — Primary key — NOT NULL
- name (Field)
- display_name (Field2)
RoleUser (role_users)
- id — Primary key — NOT NULL
- role_id (rold_id) — Foreign key → Role.id — NOT NULL
- user_id — Foreign key → User.id — NOT NULL
RoleUser (Untitled11)
- id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- role_id (Key2) — Foreign key → Role.id — NOT NULL
- id (Key22) — Foreign key → User.branch_id — NOT NULL
User (Untitled)
- id — Primary key — NOT NULL
- email
- password
User (Untitled4)
- id (Key) — Primary key — NOT NULL
- branch_id (Key2) — Foreign key → Branche.id — NOT NULL
- account (Field)
- password (Field2)
UserInfo (Untitled7)
- id (Key) — Primary key — NOT NULL
- branch_id (Key2) — Foreign key → Branche.id — NOT NULL
- name (Field)
- affiliation (Field2)
- birth (Field3)
- gender (Field4)
- pay_type (Field5)
- contact (Field6)
- bank (Field7)
- account (Field8)
- identification (Field9)
- account_holder (Field10)
- first_workday (Field11)