rdb.Column("end_date", rdb.DateTime(timezone=False), nullable=False), # type for polymorphic_identity rdb.Column("item_type", rdb.String(30), nullable=False), ) hansard_parliamentary_items = rdb.Table( "hansard_parliamentary_items", metadata, rdb.Column( "hansard_parliamentary_item_id", rdb.Integer, rdb.ForeignKey("hansard_items.hansard_item_id"), primary_key=True ), rdb.Column("parliamentary_item_id", rdb.Integer, rdb.ForeignKey("parliamentary_items.parliamentary_item_id")), ) hansard_parliamentary_item_changes = make_changes_table(hansard_parliamentary_items, metadata) hansard_parliamentary_item_versions = make_versions_table(hansard_parliamentary_items, metadata) #!+ TODO(miano, 26-Oct-2010) : Rethink this.... # Stores the name of the person speaking if they are not currently a bungeni # user otherwise stores their user_id speechs = rdb.Table( "speechs", metadata, rdb.Column("speech_id", rdb.Integer, rdb.ForeignKey("hansard_items.hansard_item_id"), primary_key=True), rdb.Column("person_id", rdb.Integer, rdb.ForeignKey("users.user_id")), rdb.Column("person_name", rdb.UnicodeText, nullable=True), rdb.Column("text", rdb.UnicodeText), ) speech_changes = make_changes_table(speechs, metadata) speech_versions = make_versions_table(speechs, metadata)
#TranscriptSequence = rdb.Sequence('transcript_id_sequence', metadata) transcript = rdb.Table( "transcript", metadata, rdb.Column('transcript_id', rdb.Integer, primary_key=True), rdb.Column("person", rdb.UnicodeText), rdb.Column("text", rdb.UnicodeText), rdb.Column("start_date", rdb.DateTime(timezone=False), nullable=False), rdb.Column("end_date", rdb.DateTime(timezone=False), nullable=False), rdb.Column("sitting_id", rdb.Integer, nullable=False), ) transcript_changes = make_changes_table(transcript, metadata) transcript_versions = make_versions_table(transcript, metadata) sitting = rdb.Table( "sitting", metadata, rdb.Column('sitting_id', rdb.Integer, primary_key=True), rdb.Column('media_path', rdb.UnicodeText, nullable=False), ) takes = rdb.Table( "take", metadata, rdb.Column('take_id', rdb.Integer, primary_key=True), rdb.Column('start_date', rdb.DateTime(timezone=False), nullable=False), rdb.Column('end_date', rdb.DateTime(timezone=False), nullable=False), rdb.Column('editor_id', rdb.Integer, nullable=False),
) hansard_parliamentary_items = rdb.Table( "hansard_parliamentary_items", metadata, rdb.Column("hansard_parliamentary_item_id", rdb.Integer, rdb.ForeignKey("hansard_items.hansard_item_id"), primary_key=True), rdb.Column("parliamentary_item_id", rdb.Integer, rdb.ForeignKey("parliamentary_items.parliamentary_item_id")), ) hansard_parliamentary_item_changes = make_changes_table( hansard_parliamentary_items, metadata) hansard_parliamentary_item_versions = make_versions_table( hansard_parliamentary_items, metadata) #!+ TODO(miano, 26-Oct-2010) : Rethink this.... # Stores the name of the person speaking if they are not currently a bungeni # user otherwise stores their user_id speechs = rdb.Table( "speechs", metadata, rdb.Column("speech_id", rdb.Integer, rdb.ForeignKey("hansard_items.hansard_item_id"), primary_key=True), rdb.Column("person_id", rdb.Integer, rdb.ForeignKey("users.user_id")), rdb.Column("person_name", rdb.UnicodeText, nullable=True), rdb.Column("text", rdb.UnicodeText), )