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