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