OfficeManagement
Tables (7)
Company
- ID (PK) — INT — Primary key — NOT NULL
- OFFICE (FK) — INT — Foreign key → Office.ID — NOT NULL
- NAME (Field) — STRING
- START (Field2) — DATE
- END (Field3) — DATE
Electric Fee Detail
- ID (PK) — INT — Primary key — NOT NULL
- COMPANY (FK) — INT — Foreign key → Company.ID — NOT NULL
- FEE INITIAL (Field) — INT
- FEE REMAINING (Field2) — INT
- MONTH (Field3) — MONTY
- YEAR (Field4) — YEAR
- PAYMENT STATE (Field5) — BOOLEAN
Gas Fee Detail
- ID (PK) — INT — Primary key — NOT NULL
- COMPANY (FK) — INT — Foreign key → Company.ID — NOT NULL
- FEE INITIAL (Field) — INT
- FEE REMAINING (Field2) — INT
- MONTH (Field3) — MONTY
- YEAR (Field4) — YEAR
- PAYMENT STATE (Field5) — BOOLEAN
Office
- ID (PK) — INT — Primary key — NOT NULL
- COMPANY (FK) — INT — Foreign key → Company.ID — NOT NULL
- MONTHLYFEE (Field) — INT
- SIZE (Field2) — INT
Payment Details
- ID (PK) — INT — Primary key — NOT NULL
- RENT FEE ID (FK) — INT — Foreign key → Rent Fee Detail.COMPANY — NOT NULL
- ELECTRIC FEE ID (FK2) — INT — Foreign key → Electric Fee Detail.COMPANY — NOT NULL
- GAS FEE ID (FK3) — INT — Foreign key → Gas Fee Detail.COMPANY — NOT NULL
- PAYMENT AMOUNT (Field) — INT
- PAYMENT DATE (Field2) — DATE
- FEE BEFORE (Field3) — INT
- FEE AFTER (Field4) — INT
Rent Fee Detail (RentFeeDetail)
- ID (PK) — INT — Primary key — NOT NULL
- COMPANY (FK) — INT — Foreign key → Company.ID — NOT NULL
- FEE INITIAL (Field) — INT
- FEE REMAINING (Field2) — INT
- MONTH (Field3) — MONTY
- YEAR (Field4) — YEAR
- PAYMENT STATE (Field5) — BOOLEAN
Vat Detail (Untitled)
- Key — Primary key — NOT NULL