0840

Tables (8)

BaseTimeEntity (Untitled8)

  • id (Key2) — INT — Primary key — NOT NULL
  • createDate (Field2) — DATETIME
  • modifiedDate (Field3) — DATETIME

DailyPattern (Untitled11)

  • dailyPatternName (Field) — String
  • timesPerMonth (Field2) — Integer
  • userId (Key) — INT — Foreign key → SiteUser.userId — NOT NULL
  • id (Key2) — INT — Foreign key → DailyPatternItemPrice.id — NOT NULL
  • id (Key22) — INT — Foreign key → DailyPatternItemType.id — NOT NULL

DailyPatternItemPrice (Untitled12)

  • id (Key2) — INT — Foreign key → BaseTimeEntity.id — NOT NULL
  • dailyConsumptionPrice (Field) — Integer

DailyPatternItemType (Untitled13)

  • id (Key2) — INT — Foreign key → BaseTimeEntity.id — NOT NULL
  • dailyConsumptionType (Field) — String

FixedSpending (Untitled10)

  • id (Key2) — INT — Foreign key → BaseTimeEntity.id — NOT NULL
  • fixedSpendingType (Field) — String
  • fixedSpending (Field2) — Integer
  • fixedSpendingMemo (Field3) — String
  • userId (Key) — INT — Foreign key → SiteUser.userId — NOT NULL

Fixedincome (Untitled3)

  • id (Key2) — INT — Foreign key → BaseTimeEntity.id — NOT NULL
  • fixedIncomeType (Field) — String
  • fixedIncome (Field2) — Integer
  • fixedIncomeMemo (Field3) — String
  • userId (Key) — INT — Foreign key → SiteUser.userId — NOT NULL

SiteUser (Untitled)

  • userId (Key) — INT — Primary key — NOT NULL
  • username (Field) — STRING
  • password (Field3) — STRING
  • nickname (Field2) — STRING
  • email (Field7) — String
  • userImgRelPath (Field4) — String
  • workPlaceName (Field5)
  • baseWage (Field10)
  • annual (Field8) — INT
  • payday (Field11) — DATETIME
  • workStartDate (Field12) — Date
  • id (Key2) — INT — Foreign key → BaseTimeEntity.id — NOT NULL
  • isRegistered (Field6) — boolean
  • isRegisteredFixedSpending (Field13) — boolean
  • isRegisteredFixedIncome (Field14) — boolean

Work (Untitled9)

  • id (Key2) — int — Primary key — NOT NULL
  • workingDate (Field) — Date
  • workingHours (Field2) — Integer
  • workingMinutes (Field3) — Integer
  • extendedHours (Field4) — Integer
  • extendedMinutes (Field5) — Integer
  • userId (Key) — INT — Foreign key → SiteUser.userId — NOT NULL
  • nightHours (Field6) — Integer
  • nightMinutes (Field7) — Integer
  • workType (Field8) — String