eyevacs4

Tables (6)

Apartment

  • id — integer — Primary key — NOT NULL
  • deleted — boolean — NOT NULL
  • updatedAt — timestamp(3) — NOT NULL
  • createdAt — timestamp(3) — NOT NULL
  • createdBy (createdAdminId) — text — NOT NULL
  • updatedBy (updatedAdminId) — text — NOT NULL

ApartmentAdmin

  • id — integer — Primary key — NOT NULL
  • name — text
  • createdAt
  • updatedAt
  • createdBy
  • updatedBy
  • deleted
  • apartmentId — integer — Foreign key → Apartment.id — NOT NULL

Household

  • id — integer — Primary key — NOT NULL
  • dong — text — NOT NULL
  • ho — text — NOT NULL
  • numDong — integer
  • numHo — integer
  • comment — text — ex
  • active — boolean — NOT NULL
  • updatedAt — timestamp(3) — NOT NULL
  • createdAt — timestamp(3) — NOT NULL
  • createdBy — text
  • updatedBy — text
  • apartmentId — integer — Foreign key → Apartment.id — NOT NULL

HouseholdCategory

  • id — integer — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text
  • enableParkingCoupon — boolean — NOT NULL
  • createdAt — timestamp(3) — NOT NULL
  • updatedAt — timestamp(3) — NOT NULL
  • deleted — boolean — NOT NULL
  • createdBy — text — NOT NULL
  • updatedBy — text
  • apartmentId — integer — Foreign key → Apartment.id — NOT NULL

category_admin (Untitled2)

  • id — integer — Primary key — NOT NULL
  • apartmentAdminId — integer — Foreign key → ApartmentAdmin.id — NOT NULL
  • categoryId — integer — Foreign key → HouseholdCategory.id — NOT NULL

household_category (Untitled)

  • id — integer — Primary key — NOT NULL
  • householdId — integer — Foreign key → Household.id — NOT NULL
  • categoryId — integer — Foreign key → HouseholdCategory.id — NOT NULL