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),
)
