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)