performance_table Table performance metadata Column id types SmallInte

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
performance_table = Table("performance", metadata,
Column("id", types.SmallInteger, primary_key=True, nullable=False, autoincrement=True),
Column("num", types.Integer, nullable=False, default=0),
Column("name", types.String(255)),
Column("sex", types.String(10)),
Column("is_dictor", types.Integer, key=True, nullable=False, default=0),
Column("lang_dictor", types.String(255)),
Column("age_dictor", types.String(100)),
Column("register_dictor", types.String(100)),
Column("timbre_dictor", types.String(100)),
Column("tempo_dictor", types.String(100)),
Column("giving_dictor", types.String(100)),
Column("ord_dictor", types.Integer, nullable=False, default=0),
Column("status_dictor", types.SmallInteger, nullable=False, default=0),
Column("outnote_dictor", types.String),
Column("meta_descr_dictor", types.String),
Column("meta_key_dictor", types.String(255)),
Column("meta_title_dictor", types.String(255)),
Column("is_vocal", types.Integer, key=True, nullable=False, default=0),
Column("lang_vocal", types.String(255)),
Column("diapason_vocal", types.String(100)),
Column("tuning_vocal", types.String(100)),
Column("role_vocal", types.String(100)),
Column("ord_vocal", types.Integer, nullable=False, default=0),
Column("status_vocal", types.SmallInteger, nullable=False, default=0),
Column("outnote_vocal", types.String),
Column("meta_descr_vocal", types.String),
Column("meta_key_vocal", types.String(255)),
Column("meta_title_vocal", types.String(255)),
Column("is_instr", types.Integer, key=True, nullable=False, default=0),
Column("instrument_instr", types.String(100)),
Column("ord_instr", types.Integer, nullable=False, default=0),
Column("status_instr", types.SmallInteger, nullable=False, default=0),
Column("outnote_instr", types.String),
Column("meta_descr_instr", types.String),
Column("meta_key_instr", types.String(255)),
Column("meta_title_instr", types.String(255))
)