worship_ppt_db

Tables (7)

auth_group

  • id — SERIAL
  • name — VARCHAR(150) — NOT NULL

auth_user

  • id — SERIAL
  • password — VARCHAR(128) — NOT NULL
  • last_login — TIMESTAMP
  • is_superuser — BOOLEAN — NOT NULL
  • username — VARCHAR(150) — NOT NULL
  • first_name — VARCHAR(150) — NOT NULL
  • last_name — VARCHAR(150) — NOT NULL
  • email — VARCHAR(254)
  • is_staff — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • date_joined — TIMESTAMP — NOT NULL

auth_user_groups

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • group_id — INTEGER — NOT NULL

core_pptrequest

  • id — SERIAL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • worship_info_id — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • generated_ppt_file — VARCHAR(100)
  • celery_task_id — VARCHAR(255)
  • progress_message — VARCHAR(255)
  • requested_by_id — INTEGER
  • completed_at — TIMESTAMP

core_ppttemplate

  • id — SERIAL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • template_file — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • description — TEXT
  • created_by_id — INTEGER

core_songinfo

  • id — SERIAL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • worship_info_id — INTEGER — NOT NULL
  • order — INTEGER — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • youtube_url — VARCHAR(500)
  • lyrics — TEXT
  • lyrics_pages — JSONB
  • created_by_id — INTEGER

core_worshipinfo

  • id — SERIAL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • worship_date — DATE — NOT NULL
  • worship_type — VARCHAR(20) — NOT NULL
  • speaker — VARCHAR(100)
  • sermon_title — VARCHAR(200)
  • sermon_scripture — VARCHAR(255)
  • announcements — TEXT
  • prayer_topic — TEXT
  • notes — TEXT
  • is_llm_processed — BOOLEAN — NOT NULL
  • created_by_id — INTEGER