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