Related Articles
v_cc_burn_permit
Purpose Community burn permit records view. Relationships v_occupancy: Many-to-One (N:1) Many permits link to one location Referenced through place_id v_cc_burn_permit_question: One-to-Many (1:N) One permit can have many questions Referenced through ...
v_cc_burn_permit_question
Purpose Burn permit questions and answers view. Relationships v_cc_burn_permit: Many-to-One (N:1) Many questions link to one permit Referenced through permit_id Table Column Type Description permit_answer_id integer Primary key question text Question ...
v_cc_smoke_alarm_request
Purpose Smoke alarm installation request view. Relationships v_occupancy: Many-to-One (N:1) Many requests link to one location Referenced through place_id v_personnel: Many-to-One (N:1) Many requests assigned to one personnel Referenced through ...
v_permit_questions
Purpose Fire department permit questions and answers. Relationships v_fd_permit: Many-to-One (N:1) Many questions link to one permit Referenced through fd_permit_id Table Column Type Description id integer Primary key fd_permit_custom_question text ...
v_fire_burn_ban_area
Purpose Fire burn ban area tracking. Relationships v_cc_burn_permit: One-to-Many (1:N) One ban area can affect many permits Referenced through geographic relationship Table Column Type Description area_id integer Primary key area_name varchar(255) ...