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