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