SchemaSpy Analysis of candlepin.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Sep 04 13:10 ADT 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

candlepin.public contains 367 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
cp_activation_key created timestamptz 35,6  √  null
cp_activation_key id varchar 32
cp_activationkey_pool.key_id fk_activation_key_pool_k
cp_activation_key name varchar 255
cp_activation_key owner_id varchar 32
cp_owner.id fk_activation_key_owner
cp_activation_key updated timestamptz 35,6  √  null
cp_activationkey_pool created timestamptz 35,6  √  null
cp_activationkey_pool id varchar 32
cp_activationkey_pool key_id varchar 32
cp_activation_key.id fk_activation_key_pool_k
cp_activationkey_pool pool_id varchar 32
cp_pool.id fk_activation_key_pool_p
cp_activationkey_pool quantity int8 19
cp_activationkey_pool updated timestamptz 35,6  √  null
cp_cert_serial collected bool 1
cp_cert_serial created timestamptz 35,6  √  null
cp_cert_serial expiration timestamptz 35,6  √  null
cp_cert_serial id int8 19
cp_certificate.serial_id fk16370c54b9410fc
cp_ent_certificate.serial_id fke76508714b9410fc
cp_id_cert.serial_id fk456324f64b9410fc
cp_cert_serial revoked bool 1
cp_cert_serial updated timestamptz 35,6  √  null
cp_certificate cert bytea 2147483647
cp_certificate created timestamptz 35,6  √  null
cp_certificate id varchar 32
cp_subscription.certificate_id fk27d80fafd8564fd9
cp_certificate privatekey bytea 2147483647
cp_certificate serial_id int8 19  √  null
cp_cert_serial.id fk16370c54b9410fc
cp_certificate updated timestamptz 35,6  √  null
cp_consumer autoheal bool 1  √  null
cp_consumer consumer_idcert_id varchar 32  √  null
cp_id_cert.id fk58205388a0b39916
cp_consumer created timestamptz 35,6  √  null
cp_consumer entitlementstatus varchar 32  √  null
cp_consumer environment_id varchar 32  √  null
cp_environment.id fk_consumer_env
cp_consumer id varchar 32
cp_consumer_facts.cp_consumer_id fk278ce810390317d
cp_consumer_guests.consumer_id fk_consumer_guests
cp_consumer_installed_products.consumer_id fk_consumer_installed_product
cp_entitlement.consumer_id fk_entitlement_consumer
cp_consumer keypair_id varchar 32  √  null
cp_key_pair.id fk5820538861936445
cp_consumer lastcheckin timestamptz 35,6  √  null
cp_consumer name varchar 255
cp_consumer owner_id varchar 32
cp_owner.id fk_consumer_owner
cp_consumer releasever varchar 255  √  null
cp_consumer servicelevel varchar 32
cp_consumer type_id varchar 32
cp_consumer_type.id fk_consumer_consumer_type
cp_consumer updated timestamptz 35,6  √  null
cp_consumer username varchar 255  √  null
cp_consumer uuid varchar 255
cp_consumer_facts cp_consumer_id varchar 32
cp_consumer.id fk278ce810390317d
cp_consumer_facts element varchar 255  √  null
cp_consumer_facts mapkey varchar 255
cp_consumer_guests consumer_id varchar 32
cp_consumer.id fk_consumer_guests
cp_consumer_guests created timestamptz 35,6  √  null
cp_consumer_guests guest_id varchar 255
cp_consumer_guests id varchar 32
cp_consumer_guests updated timestamptz 35,6  √  null
cp_consumer_installed_products consumer_id varchar 32
cp_consumer.id fk_consumer_installed_product
cp_consumer_installed_products created timestamptz 35,6  √  null
cp_consumer_installed_products id varchar 32
cp_consumer_installed_products product_id varchar 255
cp_consumer_installed_products product_name varchar 255  √  null
cp_consumer_installed_products updated timestamptz 35,6  √  null
cp_consumer_type created timestamptz 35,6  √  null
cp_consumer_type id varchar 32
cp_consumer.type_id fk_consumer_consumer_type
cp_consumer_type label varchar 255
cp_consumer_type manifest bpchar 1
cp_consumer_type updated timestamptz 35,6  √  null
cp_content contenturl varchar 255  √  null
cp_content created timestamptz 35,6  √  null
cp_content gpgurl varchar 255  √  null
cp_content id varchar 255
cp_content_modified_products.cp_content_id fkc93d6a8232912b37
cp_product_content.content_id fkce093157574ef825
cp_content label varchar 255
cp_content metadataexpire int8 19  √  null
cp_content name varchar 255
cp_content releasever varchar 255  √  null
cp_content requiredtags varchar 255  √  null
cp_content type varchar 255
cp_content updated timestamptz 35,6  √  null
cp_content vendor varchar 255
cp_content_modified_products cp_content_id varchar 255
cp_content.id fkc93d6a8232912b37
cp_content_modified_products element varchar 255  √  null
cp_deleted_consumers consumer_uuid varchar 255
cp_deleted_consumers created timestamptz 35,6  √  null
cp_deleted_consumers id varchar 32
cp_deleted_consumers owner_id varchar 32
cp_deleted_consumers updated timestamptz 35,6  √  null
cp_ent_certificate cert bytea 2147483647
cp_ent_certificate created timestamptz 35,6  √  null
cp_ent_certificate entitlement_id varchar 32
cp_entitlement.id fk_cert_entitlement
cp_ent_certificate id varchar 32
cp_ent_certificate privatekey bytea 2147483647
cp_ent_certificate serial_id int8 19  √  null
cp_cert_serial.id fke76508714b9410fc
cp_ent_certificate updated timestamptz 35,6  √  null
cp_entitlement accountnumber varchar 255  √  null
cp_entitlement consumer_id varchar 32
cp_consumer.id fk_entitlement_consumer
cp_entitlement contractnumber varchar 255  √  null
cp_entitlement created timestamptz 35,6  √  null
cp_entitlement dirty bool 1  √  false
cp_entitlement enddate timestamptz 35,6  √  null
cp_entitlement id varchar 32
cp_ent_certificate.entitlement_id fk_cert_entitlement
cp_pool.sourceentitlement_id fk_pool_source_entitlement
cp_entitlement owner_id varchar 32
cp_owner.id fk_entitlement_owner
cp_entitlement pool_id varchar 32  √  null
cp_pool.id fk_entitlement_pool
cp_entitlement quantity int4 10  √  null
cp_entitlement startdate timestamptz 35,6  √  null
cp_entitlement updated timestamptz 35,6  √  null
cp_env_content contentid varchar 255
cp_env_content created timestamptz 35,6  √  null
cp_env_content enabled bool 1  √  null
cp_env_content environment_id varchar 32
cp_environment.id fk_env_content_env
cp_env_content id varchar 32
cp_env_content updated timestamptz 35,6  √  null
cp_environment created timestamptz 35,6  √  null
cp_environment description varchar 255  √  null
cp_environment id varchar 32
cp_consumer.environment_id fk_consumer_env
cp_env_content.environment_id fk_env_content_env
cp_environment name varchar 255
cp_environment owner_id varchar 32
cp_owner.id fk_env_owner
cp_environment updated timestamptz 35,6  √  null
cp_event consumerid varchar 255  √  null
cp_event entityid varchar 255
cp_event id varchar 32
cp_event ownerid varchar 255
cp_event principal varchar 255
cp_event referenceid varchar 255  √  null
cp_event referencetype varchar 255  √  null
cp_event target varchar 255
cp_event targetname varchar 255  √  null
cp_event timestamp timestamptz 35,6
cp_event type varchar 255
cp_export_metadata created timestamptz 35,6  √  null
cp_export_metadata exported timestamptz 35,6
cp_export_metadata id varchar 32
cp_export_metadata owner_id varchar 32  √  null
cp_owner.id fkf06f6b8872cc5ca5
cp_export_metadata type varchar 255
cp_export_metadata updated timestamptz 35,6  √  null
cp_id_cert cert bytea 2147483647
cp_id_cert created timestamptz 35,6  √  null
cp_id_cert id varchar 32
cp_consumer.consumer_idcert_id fk58205388a0b39916
cp_id_cert privatekey bytea 2147483647
cp_id_cert serial_id int8 19  √  null
cp_cert_serial.id fk456324f64b9410fc
cp_id_cert updated timestamptz 35,6  √  null
cp_import_record created timestamptz 35,6  √  null
cp_import_record generated_by varchar 255  √  null
cp_import_record generated_date timestamptz 35,6  √  null
cp_import_record id varchar 32
cp_import_record owner_id varchar 32  √  null
cp_owner.id fk9349dd972cc5ca5
cp_import_record status int4 10  √  null
cp_import_record statusmessage varchar 255  √  null
cp_import_record updated timestamptz 35,6  √  null
cp_import_record upstream_id varchar 255  √  null
cp_import_record upstream_name varchar 255  √  null
cp_import_record upstream_type varchar 255  √  null
cp_import_record webapp_prefix varchar 255  √  null
cp_job created timestamptz 35,6  √  null
cp_job finishtime timestamptz 35,6  √  null
cp_job id varchar 255
cp_job jobgroup varchar 15  √  null
cp_job principalname varchar 255  √  null
cp_job result varchar 255  √  null
cp_job starttime timestamptz 35,6  √  null
cp_job state int4 10  √  null
cp_job targetid varchar 255  √  null
cp_job targettype int4 10  √  null
cp_job updated timestamptz 35,6  √  null
cp_key_pair created timestamptz 35,6  √  null
cp_key_pair id varchar 32
cp_consumer.keypair_id fk5820538861936445
cp_key_pair privatekey bytea 2147483647  √  null
cp_key_pair publickey bytea 2147483647  √  null
cp_key_pair updated timestamptz 35,6  √  null
cp_owner account varchar 255
cp_owner contentprefix varchar 255  √  null
cp_owner created timestamptz 35,6  √  null
cp_owner defaultservicelevel varchar 255  √  null
cp_owner displayname varchar 255
cp_owner id varchar 32
cp_activation_key.owner_id fk_activation_key_owner
cp_consumer.owner_id fk_consumer_owner
cp_entitlement.owner_id fk_entitlement_owner
cp_environment.owner_id fk_env_owner
cp_export_metadata.owner_id fkf06f6b8872cc5ca5
cp_import_record.owner_id fk9349dd972cc5ca5
cp_owner.parent_owner fkf93e9c616343755c
cp_owner_permission.owner_id fk_permission_owner
cp_pool.owner_id fk_pool_owner
cp_subscription.owner_id fk_subscription_owner
cp_owner parent_owner varchar 32  √  null
cp_owner.id fkf93e9c616343755c
cp_owner updated timestamptz 35,6  √  null
cp_owner upstream_uuid varchar 255  √  null
cp_owner_permission access int4 10  √  null
cp_owner_permission created timestamptz 35,6  √  null
cp_owner_permission id varchar 32
cp_owner_permission owner_id varchar 32
cp_owner.id fk_permission_owner
cp_owner_permission role_id varchar 32
cp_role.id fk_permission_role
cp_owner_permission updated timestamptz 35,6  √  null
cp_pool accountnumber varchar 255  √  null
cp_pool activesubscription bool 1  √  null
cp_pool contractnumber varchar 255  √  null
cp_pool created timestamptz 35,6  √  null
cp_pool enddate timestamptz 35,6
cp_pool id varchar 32
cp_activationkey_pool.pool_id fk_activation_key_pool_p
cp_entitlement.pool_id fk_entitlement_pool
cp_pool_attribute.pool_id fk_pool_id
cp_pool_products.pool_id fk_pool_provided_product
cp_product_pool_attribute.pool_id fk_pool_id
cp_pool owner_id varchar 32
cp_owner.id fk_pool_owner
cp_pool productid varchar 255
cp_pool productname varchar 255  √  null
cp_pool quantity int8 19
cp_pool restrictedtousername varchar 255  √  null
cp_pool sourceentitlement_id varchar 32  √  null
cp_entitlement.id fk_pool_source_entitlement
cp_pool startdate timestamptz 35,6
cp_pool subscriptionid varchar 255  √  null
cp_pool subscriptionsubkey varchar 255  √  null
cp_pool updated timestamptz 35,6  √  null
cp_pool version int4 10
cp_pool_attribute created timestamptz 35,6  √  null
cp_pool_attribute id varchar 32
cp_pool_attribute name varchar 255
cp_pool_attribute pool_id varchar 32
cp_pool.id fk_pool_id
cp_pool_attribute updated timestamptz 35,6  √  null
cp_pool_attribute value varchar 255  √  null
cp_pool_products created timestamptz 35,6  √  null
cp_pool_products id varchar 32
cp_pool_products pool_id varchar 32
cp_pool.id fk_pool_provided_product
cp_pool_products product_id varchar 255
cp_pool_products product_name varchar 255  √  null
cp_pool_products updated timestamptz 35,6  √  null
cp_product created timestamptz 35,6  √  null
cp_product id varchar 32
cp_product_attribute.product_id fk_product_id
cp_product_certificate.product_id fk_cert_product
cp_product_content.product_id fkce09315764dd9c65
cp_product_dependent_products.cp_product_id fk9ef75306401fcf77
cp_subscription.product_id fk_subscription_product
cp_subscription_products.product_id fk_subscription_id
cp_product multiplier int8 19  √  null
cp_product name varchar 255
cp_product updated timestamptz 35,6  √  null
cp_product_attribute created timestamptz 35,6  √  null
cp_product_attribute id varchar 255
cp_product_attribute name varchar 255
cp_product_attribute product_id varchar 32
cp_product.id fk_product_id
cp_product_attribute updated timestamptz 35,6  √  null
cp_product_attribute value varchar 255  √  null
cp_product_certificate cert bytea 2147483647
cp_product_certificate created timestamptz 35,6  √  null
cp_product_certificate id varchar 32
cp_product_certificate privatekey bytea 2147483647
cp_product_certificate product_id varchar 32
cp_product.id fk_cert_product
cp_product_certificate updated timestamptz 35,6  √  null
cp_product_content content_id varchar 255
cp_content.id fkce093157574ef825
cp_product_content created timestamptz 35,6  √  null
cp_product_content enabled bool 1  √  null
cp_product_content product_id varchar 32
cp_product.id fkce09315764dd9c65
cp_product_content updated timestamptz 35,6  √  null
cp_product_dependent_products cp_product_id varchar 32
cp_product.id fk9ef75306401fcf77
cp_product_dependent_products element varchar 255  √  null
cp_product_pool_attribute created timestamptz 35,6  √  null
cp_product_pool_attribute id varchar 32
cp_product_pool_attribute name varchar 255
cp_product_pool_attribute pool_id varchar 32
cp_pool.id fk_pool_id
cp_product_pool_attribute productid varchar 255
cp_product_pool_attribute updated timestamptz 35,6  √  null
cp_product_pool_attribute value varchar 255  √  null
cp_role created timestamptz 35,6  √  null
cp_role id varchar 32
cp_owner_permission.role_id fk_permission_role
cp_role_users.role_id fk_user_id
cp_role name varchar 255
cp_role updated timestamptz 35,6  √  null
cp_role_users role_id varchar 32
cp_role.id fk_user_id
cp_role_users user_id varchar 32
cp_user.id fk_role_id
cp_rules created timestamptz 35,6  √  null
cp_rules id varchar 32
cp_rules rules_blob text 2147483647  √  null
cp_rules updated timestamptz 35,6  √  null
cp_stat_history created timestamptz 35,6  √  null
cp_stat_history entry_type varchar 255
cp_stat_history id varchar 32
cp_stat_history owner_id varchar 255  √  null
cp_stat_history updated timestamptz 35,6  √  null
cp_stat_history value int4 10
cp_stat_history value_reference varchar 255  √  null
cp_stat_history value_type varchar 255  √  null
cp_subscription accountnumber varchar 255  √  null
cp_subscription certificate_id varchar 32  √  null
cp_certificate.id fk27d80fafd8564fd9
cp_subscription contractnumber varchar 255  √  null
cp_subscription created timestamptz 35,6  √  null
cp_subscription enddate timestamptz 35,6
cp_subscription id varchar 32
cp_subscription_products.subscription_id fk_product_id
cp_subscription modified timestamptz 35,6  √  null
cp_subscription owner_id varchar 32
cp_owner.id fk_subscription_owner
cp_subscription product_id varchar 32
cp_product.id fk_subscription_product
cp_subscription quantity int8 19
cp_subscription startdate timestamptz 35,6
cp_subscription updated timestamptz 35,6  √  null
cp_subscription upstream_pool_id varchar 255  √  null
cp_subscription_products product_id varchar 32
cp_product.id fk_subscription_id
cp_subscription_products subscription_id varchar 32
cp_subscription.id fk_product_id
cp_user created timestamptz 35,6  √  null
cp_user hashedpassword varchar 255  √  null
cp_user id varchar 32
cp_role_users.user_id fk_role_id
cp_user superadmin bool 1
cp_user updated timestamptz 35,6  √  null
cp_user username varchar 255
databasechangelog author varchar 63
databasechangelog comments varchar 255  √  null
databasechangelog dateexecuted timestamptz 35,6
databasechangelog description varchar 255  √  null
databasechangelog exectype varchar 10
databasechangelog filename varchar 200
databasechangelog id varchar 63
databasechangelog liquibase varchar 20  √  null
databasechangelog md5sum varchar 35  √  null
databasechangelog orderexecuted int4 10
databasechangelog tag varchar 255  √  null
databasechangeloglock id int4 10
databasechangeloglock locked bool 1
databasechangeloglock lockedby varchar 255  √  null
databasechangeloglock lockgranted timestamptz 35,6  √  null
qrtz_blob_triggers blob_data bytea 2147483647  √  null
qrtz_blob_triggers sched_name varchar 120 'TestScheduler'::character varying
qrtz_triggers.sched_name qrtz_blob_triggers_trigger_name_fkey
qrtz_blob_triggers trigger_group varchar 200
qrtz_triggers.trigger_group qrtz_blob_triggers_trigger_name_fkey
qrtz_blob_triggers trigger_name varchar 200
qrtz_triggers.trigger_name qrtz_blob_triggers_trigger_name_fkey
qrtz_calendars calendar bytea 2147483647
qrtz_calendars calendar_name varchar 200
qrtz_calendars sched_name varchar 120 'TestScheduler'::character varying
qrtz_cron_triggers cron_expression varchar 120
qrtz_cron_triggers sched_name varchar 120 'TestScheduler'::character varying
qrtz_triggers.sched_name qrtz_cron_triggers_trigger_name_fkey
qrtz_cron_triggers time_zone_id varchar 80  √  null
qrtz_cron_triggers trigger_group varchar 200
qrtz_triggers.trigger_group qrtz_cron_triggers_trigger_name_fkey
qrtz_cron_triggers trigger_name varchar 200
qrtz_triggers.trigger_name qrtz_cron_triggers_trigger_name_fkey
qrtz_fired_triggers entry_id varchar 95
qrtz_fired_triggers fired_time int8 19
qrtz_fired_triggers instance_name varchar 200
qrtz_fired_triggers is_nonconcurrent bool 1  √  null
qrtz_fired_triggers is_update_data bool 1  √  null
qrtz_fired_triggers job_group varchar 200  √  null
qrtz_fired_triggers job_name varchar 200  √  null
qrtz_fired_triggers priority int4 10
qrtz_fired_triggers requests_recovery bool 1  √  null
qrtz_fired_triggers sched_name varchar 120 'TestScheduler'::character varying
qrtz_fired_triggers state varchar 16
qrtz_fired_triggers trigger_group varchar 200
qrtz_fired_triggers trigger_name varchar 200
qrtz_job_details description varchar 250  √  null
qrtz_job_details is_durable bool 1
qrtz_job_details is_nonconcurrent bool 1  √  null
qrtz_job_details is_update_data bool 1  √  null
qrtz_job_details job_class_name varchar 250
qrtz_job_details job_data bytea 2147483647  √  null
qrtz_job_details job_group varchar 200
qrtz_triggers.job_group qrtz_triggers_job_name_fkey
qrtz_job_details job_name varchar 200
qrtz_triggers.job_name qrtz_triggers_job_name_fkey
qrtz_job_details requests_recovery bool 1
qrtz_job_details sched_name varchar 120 'TestScheduler'::character varying
qrtz_triggers.sched_name qrtz_triggers_job_name_fkey
qrtz_locks lock_name varchar 40
qrtz_locks sched_name varchar 120 'TestScheduler'::character varying
qrtz_paused_trigger_grps sched_name varchar 120 'TestScheduler'::character varying
qrtz_paused_trigger_grps trigger_group varchar 200
qrtz_scheduler_state checkin_interval int8 19
qrtz_scheduler_state instance_name varchar 200
qrtz_scheduler_state last_checkin_time int8 19
qrtz_scheduler_state sched_name varchar 120 'TestScheduler'::character varying
qrtz_simple_triggers repeat_count int8 19
qrtz_simple_triggers repeat_interval int8 19
qrtz_simple_triggers sched_name varchar 120 'TestScheduler'::character varying
qrtz_triggers.sched_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simple_triggers times_triggered int8 19
qrtz_simple_triggers trigger_group varchar 200
qrtz_triggers.trigger_group qrtz_simple_triggers_trigger_name_fkey
qrtz_simple_triggers trigger_name varchar 200
qrtz_triggers.trigger_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers bool_prop_1 bool 1  √  null
qrtz_simprop_triggers bool_prop_2 bool 1  √  null
qrtz_simprop_triggers dec_prop_1 numeric 13,4  √  null
qrtz_simprop_triggers dec_prop_2 numeric 13,4  √  null
qrtz_simprop_triggers int_prop_1 int4 10  √  null
qrtz_simprop_triggers int_prop_2 int4 10  √  null
qrtz_simprop_triggers long_prop_1 int8 19  √  null
qrtz_simprop_triggers long_prop_2 int8 19  √  null
qrtz_simprop_triggers sched_name varchar 120
qrtz_triggers.sched_name qrtz_simprop_triggers_trigger_name_fkey
qrtz_simprop_triggers str_prop_1 varchar 512  √  null
qrtz_simprop_triggers str_prop_2 varchar 512  √  null
qrtz_simprop_triggers str_prop_3 varchar 512  √  null
qrtz_simprop_triggers trigger_group varchar 200
qrtz_triggers.trigger_group qrtz_simprop_triggers_trigger_name_fkey
qrtz_simprop_triggers trigger_name varchar 200
qrtz_triggers.trigger_name qrtz_simprop_triggers_trigger_name_fkey
qrtz_triggers calendar_name varchar 200  √  null
qrtz_triggers description varchar 250  √  null
qrtz_triggers end_time int8 19  √  null
qrtz_triggers job_data bytea 2147483647  √  null
qrtz_triggers job_group varchar 200
qrtz_job_details.job_group qrtz_triggers_job_name_fkey
qrtz_triggers job_name varchar 200
qrtz_job_details.job_name qrtz_triggers_job_name_fkey
qrtz_triggers misfire_instr int2 5  √  null
qrtz_triggers next_fire_time int8 19  √  null
qrtz_triggers prev_fire_time int8 19  √  null
qrtz_triggers priority int4 10  √  null
qrtz_triggers sched_name varchar 120 'TestScheduler'::character varying
qrtz_blob_triggers.sched_name qrtz_blob_triggers_trigger_name_fkey
qrtz_cron_triggers.sched_name qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.sched_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.sched_name qrtz_simprop_triggers_trigger_name_fkey
qrtz_job_details.sched_name qrtz_triggers_job_name_fkey
qrtz_triggers start_time int8 19
qrtz_triggers trigger_group varchar 200
qrtz_blob_triggers.trigger_group qrtz_blob_triggers_trigger_name_fkey
qrtz_cron_triggers.trigger_group qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.trigger_group qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.trigger_group qrtz_simprop_triggers_trigger_name_fkey
qrtz_triggers trigger_name varchar 200
qrtz_blob_triggers.trigger_name qrtz_blob_triggers_trigger_name_fkey
qrtz_cron_triggers.trigger_name qrtz_cron_triggers_trigger_name_fkey
qrtz_simple_triggers.trigger_name qrtz_simple_triggers_trigger_name_fkey
qrtz_simprop_triggers.trigger_name qrtz_simprop_triggers_trigger_name_fkey
qrtz_triggers trigger_state varchar 16
qrtz_triggers trigger_type varchar 8