ChurchAccounting
Tables (10)
Category (Untitled2)
- category_id (Key) — Integer — Primary key — NOT NULL
- organization_id (Key2) — Integer — Foreign key → Organization.organization_id — NOT NULL
- name (Field) — String
- tx_type (Field2) — Enum
- year (Field3) — Integer
Event (Untitled4)
- event_id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
- start_date (Field2) — Date
- end_date (Field3) — Date
- description (Field4) — String
- year (Field5) — Integer
FileInfo (Untitled)
- file_info_id (Key) — Integer — Primary key — NOT NULL
- file_name (Field) — String
- year (Field2) — Integer
- uploaded_at (Field3) — DateTime
Item (Untitled3)
- item_id (Key) — Integer — Primary key — NOT NULL
- category_id (Key2) — Integer — Foreign key → Category.category_id — NOT NULL
- organization_id (Key22) — Integer — Foreign key → Category.organization_id — NOT NULL
- name (Field) — String
- year (Field2) — Integer
JoinedOrganization (Untitled10)
- join_organizaiton_id (Key) — Integer — Primary key — NOT NULL
- organization_id (Key2) — Integer — Foreign key → Organization.organization_id — NOT NULL
- member_id (Key3) — Integer — Foreign key → Member.member_id — NOT NULL
- member_role (Field) — Enum
- joined_at (Field2) — DateTime
Member (Untitled6)
- member_id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
- email (Field2) — String
- hashed_password (Field3) — String
- email_verified (Field4) — Boolean
Organization (Untitled8)
- organization_id (Key) — Integer — Primary key — NOT NULL
- name (Field) — String
- description (Field2) — String
- start_year (Field3) — Integer
- end_year (Field4) — Integer
- deleted (Field5) — Boolean
- deleted_at (Field6) — DateTime
OrganizationInvitation (Untitled9)
- organization_invitation_id (Key) — Integer — Primary key — NOT NULL
- member_id (Key2) — Integer — Foreign key → Member.member_id — NOT NULL
- organization_id (Key3) — Integer — Foreign key → Organization.organization_id — NOT NULL
- status (Field) — Enum
Receipt (Untitled5)
- receipt_id (Key) — Integer — Primary key — NOT NULL
- organization_id (Key2) — Integer — Foreign key → Organization.organization_id — NOT NULL
- item_id (Key3) — Integer — Foreign key → Item.item_id — NOT NULL
- category_id (Key22) — Integer — Foreign key → Item.category_id — NOT NULL
- event_id (Key4) — Integer — Foreign key → Event.event_id — NOT NULL
- organization_id (Key222) — Integer — Foreign key → Item.organization_id — NOT NULL
- category_id (Key5) — Integer — Foreign key → Category.category_id — NOT NULL
- organization_id (Key23) — Integer — Foreign key → Category.organization_id — NOT NULL
- paper_date (Field) — Date
- actual_date (Field2) — Date
- name (Field3) — String
- tx_type (Field4) — Enum
- amount (Field5) — Integer
- etc (Field6) — String
- year (Field7) — Integer
RefreshToken (Untitled7)
- refresh_token_id (Key) — Integer — Primary key — NOT NULL
- member_id (Key2) — Integer — Foreign key → Member.member_id — NOT NULL
- hash_token (Field) — String
- jti (Field2) — String
- issued_at (Field3) — DateTime
- expired_at (Field4) — DateTime
- ip_address (Field5) — String
- user_agent (Field6) — String