)
attached_files = rdb.Table("attached_files", metadata,
rdb.Column("attached_file_id", rdb.Integer, primary_key=True),
# the id of the "owning" item !+HEAD_DOCUMENT_ITEM
rdb.Column("item_id", rdb.Integer,
rdb.ForeignKey("parliamentary_items.parliamentary_item_id"),
nullable=False
),
rdb.Column("attached_file_type_id", rdb.Integer,
rdb.ForeignKey("attached_file_types.attached_file_type_id"),
nullable=False
),
rdb.Column("file_version_id", rdb.Integer), # !+ATTACHED_FILE_VERSIONS
rdb.Column("file_title", rdb.Unicode(255), nullable=False),
rdb.Column("file_description", rdb.UnicodeText),
rdb.Column("file_data", FSBlob(32)),
rdb.Column("file_name", rdb.String(200)),
rdb.Column("file_mimetype", rdb.String(127)),
# Workflow State
rdb.Column("status", rdb.Unicode(48)),
rdb.Column("status_date", rdb.DateTime(timezone=False),
server_default=(text("now()")),
nullable=False
),
rdb.Column("language", rdb.String(5), nullable=False),
)
attached_files_index = rdb.Index("attfiles_itemid_idx",
attached_files.c["item_id"]
)
registrySequence = rdb.Sequence("registry_number_sequence", metadata = metadata)
sa.Column("time", sa.Time(timezone=False)),
sa.Column("issue_item", sa.Unicode(1024)),
sa.Column("issue_sub_item", sa.Unicode(1024)),
sa.Column("document_uri", sa.Unicode(1024)),
sa.Column("question", sa.Unicode(1024)),
sa.Column("description", sa.UnicodeText),
sa.Column("notes", sa.UnicodeText),
sa.Column("result", sa.Unicode(255)),
sa.Column("vote_type", sa.Unicode(255)),
sa.Column("majority_type", sa.Unicode(255)),
sa.Column("eligible_votes", sa.Integer),
sa.Column("cast_votes", sa.Integer),
sa.Column("votes_for", sa.Integer),
sa.Column("votes_against", sa.Integer),
sa.Column("votes_abstained", sa.Integer),
sa.Column("roll_call", FSBlob(32)),
sa.Column("mimetype", sa.Unicode(127)),
sa.Column("language", sa.String(5), nullable=False, default="en"),
)
sitting_report = sa.Table(
"sitting_report",
metadata,
sa.Column("report_id",
sa.Integer,
sa.ForeignKey("doc.doc_id"),
primary_key=True),
sa.Column("sitting_id",
sa.Integer,
sa.ForeignKey("sitting.sitting_id"),
primary_key=True),
# the id of the "owning" head document
# !+doc_attachment -- this assumes that attachments are only for doc?
rdb.Column("head_id",
rdb.Integer,
rdb.ForeignKey("doc.doc_id"),
nullable=False),
# attachment_type #!+attached_file_type
rdb.Column(
"type",
rdb.Unicode(128),
default="document",
nullable=False,
),
rdb.Column("title", rdb.Unicode(255), nullable=False), #!+file
rdb.Column("description", rdb.UnicodeText), #!+file
rdb.Column("data", FSBlob(32)), #!+file
rdb.Column("name", rdb.String(200)), #!+file
rdb.Column("mimetype", rdb.String(127)), #!+file
# Workflow State
rdb.Column("status", rdb.Unicode(48)),
rdb.Column("status_date",
rdb.DateTime(timezone=False),
server_default=text("now()"),
nullable=False),
rdb.Column("language", rdb.String(5), nullable=False),
)
attachment_index = rdb.Index("attachment_head_id_idx", attachment.c["head_id"])
# attachment_audit
attachment_audit = make_audit_table(attachment, metadata)