App v4.1.15
Source | Wiki

Church of the Ascension, Parkesburg

Family Directory Management

Retrieved Database Connection Information

• Database Name: cotadirectory
• User: cotauser@localhost
• Host: Localhost via UNIX socket
• Port: default
• client_info: mysqlnd 8.1.34
• server_info: 8.0.46-37

• families (Records: 31)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • familyname - varchar(50) - Null: NO
  • address - varchar(50) - Null: YES
  • address2 - varchar(50) - Null: YES
  • address3 - varchar(50) - Null: YES
  • city - varchar(20) - Null: YES
  • state - varchar(10) - Null: YES
  • zip - varchar(10) - Null: YES
  • homephone - varchar(20) - Null: YES
• leadership (Records: 4)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • member_id - int - Null: NO
  • leadership_position - varchar(25) - Null: YES
• member_passwords (Records: 0)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • member_id - int - Null: NO - Key: MUL
  • email - varchar(100) - Null: NO - Key: UNI
  • password_hash - varchar(255) - Null: NO
  • created_at - timestamp - Null: YES - Default: CURRENT_TIMESTAMP - Extra: DEFAULT_GENERATED
  • updated_at - timestamp - Null: YES - Default: CURRENT_TIMESTAMP - Extra: DEFAULT_GENERATED on update CURRENT_TIMESTAMP
• members (Records: 65)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • family_id - int - Null: NO - Key: MUL
  • first_name - varchar(50) - Null: YES
  • last_name - varchar(50) - Null: YES
  • cell_phone - varchar(20) - Null: YES
  • email - varchar(100) - Null: YES
  • birthday - date - Null: YES
  • baptism - date - Null: YES
  • anniversary - date - Null: YES
• staff (Records: 4)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • member_id - int - Null: NO
  • position - varchar(50) - Null: YES
  • staff_title - varchar(5) - Null: YES
  • staff_first_name - varchar(50) - Null: YES
  • staff_last_name - varchar(50) - Null: YES
  • staff_phone - varchar(30) - Null: YES
  • staff_email - varchar(100) - Null: YES
• vestry (Records: 7)
  • id - int - Null: NO - Key: PRI - Extra: auto_increment
  • member_id - int - Null: NO
  • class - varchar(4) - Null: YES
  • vrole - varchar(25) - Null: YES
  • liaison - varchar(50) - Null: YES