oats_documents

-1 rows


Description

A DOCUMENT is a human readable (opened with the appropriate software) electronic file .DOCUMENTS are typically: PDF (Portable Document Format) files JPEG (Joint Photographic Experts Group) photographs

Columns

Column Type Size Nulls Auto Default Children Parents Comments
document_id int8 19 null

System generated sequence number to uniquely identify a DOCUMENT.
document_code varchar 10 null
oats_document_codes.document_code oats_docu_docd_fk R

User supplied value to uniquely identify a DOCUMENT CODE
alr_application_id int8 19 √ null
oats_alr_applications.alr_application_id oats_docu_appl_fk R

System generated sequence number to uniquely identify an ALR APPLICATION. This is also used as the ALR APPLICATION’S external reference number.
issue_id int8 19 √ null
oats_issues.issue_id oats_docu_issu_fk R

System generated sequence number to uniquely identify an ISSUE
planning_review_id int8 19 √ null
oats_planning_reviews.planning_review_id oats_docu_plrv_fk R

System generated sequence number to uniquely identify a PLANNING REVIEW
file_name varchar 128 null

Filename, including the extension, excluding the directory path, of the source document. This will be used for the initial ‘save as…’ file name when the document is downloaded from the application. The file name must include one period so the file extension can be derived.
description varchar 100 √ null

Description of the DOCUMENT
referenced_in_staff_rpt_ind varchar 1 null

Indicates whether or not this DOCUMENT will be referenced as an attachment in the Staff Report. This option is only applicable for ALR APPLICATION related DOCUMENTS, therefore this may be Yes or No if the relationship from ALR APPLICATION is supplied, but must always be No if the relationship from ISSUE or PLANNING REVIEW is supplied.
document_source_code varchar 10 null
oats_document_source_codes.document_source_code oats_od_dsc_fk R

The source of the document.
subject_property_id int8 19 √ null
oats_subject_properties.subject_property_id oats_od_sp_fk R

The property associated with the document
publicly_viewable_ind varchar 1 'Y'::character varying

Indicates if the document can be viewed by the public.
app_lg_viewable_ind varchar 1 'Y'::character varying

Indicates if the document can be viewed by the applicant and local government.
uploaded_date timestamp 29,6 null

The date the document was uploaded.
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was last updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_documents_pkey Primary key Asc document_id
oats_docu_appl_fk_i Performance Asc alr_application_id
oats_docu_docd_fk_i Performance Asc document_code
oats_docu_issu_fk_i Performance Asc issue_id
oats_docu_plrv_fk_i Performance Asc planning_review_id

Check Constraints

Constraint Name Constraint
oats_od_risri_chk ((referenced_in_staff_rpt_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_docu_chk (((alr_application_id IS NOT NULL) AND (issue_id IS NULL) AND (planning_review_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NOT NULL) AND (planning_review_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NULL) AND (planning_review_id IS NOT NULL)))
oats_od_alvi_chk ((app_lg_viewable_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_od_pvi_chk ((publicly_viewable_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))

Relationships

Close relationships within degrees of separation