app_certificate

0 rows


Description

Defines certificates

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_certificate_id_seq'::regclass)
app_certificate_issues_history.certificateid Defined in XMLR
course int8 19 0
name varchar 255 ''::character varying
intro text 2147483647 null
introformat int2 5 0
emailteachers int2 5 0
emailothers text 2147483647 null
savecert int2 5 0
reportcert int2 5 0
delivery int2 5 0
requiredtime int8 19 0
certificatetype varchar 50 ''::character varying
orientation varchar 10 ''::character varying
borderstyle varchar 255 '0'::character varying
bordercolor varchar 30 '0'::character varying
printwmark varchar 255 '0'::character varying
printdate int8 19 0
datefmt int8 19 0
printnumber int2 5 0
printgrade int8 19 0
gradefmt int8 19 0
printoutcome int8 19 0
printhours varchar 255 null
printteacher int8 19 0
customtext text 2147483647 null
printsignature varchar 255 '0'::character varying
printseal varchar 255 '0'::character varying
timecreated int8 19 0
timemodified int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_cert_id_pk Primary key Asc id

Relationships