|
event_id
|
INT
|
|
|
|
|
event_category_id
|
INT
|
|
|
|
|
event_partnership_id
|
char(2)
|
latin1_swedish_ci
|
|
|
|
event_barcode
|
varchar(7)
|
latin1_swedish_ci
|
|
|
|
event_name
|
text
|
latin1_swedish_ci
|
|
|
|
event_topic_group
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
event_institution_group_id
|
char(2)
|
latin1_swedish_ci
|
|
|
|
event_institution_ownership_id
|
char(2)
|
latin1_swedish_ci
|
|
|
|
event_institution_code_old
|
char(11)
|
latin1_swedish_ci
|
|
|
|
event_institution_code
|
varchar(11)
|
latin1_swedish_ci
|
|
|
|
event_institution_name
|
varchar(250)
|
latin1_swedish_ci
|
|
|
|
event_institution_id
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
event_location_id
|
INT
|
|
|
|
|
event_province_code
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
event_province_name
|
varchar(25)
|
latin1_swedish_ci
|
|
|
|
event_city_code
|
INT
|
|
|
|
|
event_city_name
|
varchar(25)
|
latin1_swedish_ci
|
|
|
|
event_certificate_date
|
varchar(25)
|
latin1_swedish_ci
|
|
|
|
event_address_other
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
event_start_date_plan
|
date
|
|
|
|
|
event_end_date_plan
|
date
|
|
|
|
|
event_start_date
|
date
|
|
|
|
|
event_end_date
|
date
|
|
|
|
|
event_note
|
text
|
latin1_swedish_ci
|
|
|
|
event_package_id
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
event_package_chapter_id
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
event_is_webinar
|
INT
|
|
|
|
|
event_is_ecertificate
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_workshop_capacity
|
INT
|
|
|
|
|
event_price
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
event_funds_source
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_price_personal
|
decimal(12,2)
|
|
|
|
|
event_is_internal
|
INT
|
|
|
|
|
event_dinkesCity_is_approved
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_dinkesCity_approve_date
|
datetime
|
|
|
|
|
event_dinkesCity_approve_by
|
INT
|
|
|
|
|
event_dinkesProv_is_approved
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_dinkesProv_approve_date
|
datetime
|
|
|
|
|
event_dinkesProv_approve_by
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
event_is_approved
|
INT
|
|
|
|
|
event_approve_date
|
datetime
|
|
|
|
|
event_approve_by
|
char(5)
|
latin1_swedish_ci
|
|
|
|
event_reply_letter_number
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
event_reply_letter_date
|
date
|
|
|
|
|
event_document_amount
|
INT
|
|
|
|
|
event_billing_pic
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
event_billing_pic_phone
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
event_institution_letter_number
|
varchar(30)
|
latin1_swedish_ci
|
|
|
|
event_institution_letter_date
|
date
|
|
|
|
|
event_invoice_number
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
event_billing_price
|
decimal(12,2)
|
|
|
|
|
event_billing_ticket
|
decimal(12,2)
|
|
|
|
|
event_billing_transport
|
decimal(12,2)
|
|
|
|
|
event_billing_close_status
|
INT
|
|
|
|
|
event_billing_close_date
|
date
|
|
|
|
|
event_billing_code_transaction
|
varchar(13)
|
latin1_swedish_ci
|
|
|
|
event_accreditation_id_reference
|
INT
|
|
|
|
|
event_id_reference
|
INT
|
|
|
|
|
event_accreditation_version
|
char(4)
|
latin1_swedish_ci
|
|
|
|
event_hospital_pic
|
INT
|
|
|
|
|
event_surveyor_amount
|
char(2)
|
latin1_swedish_ci
|
|
|
|
event_participant_amount
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
event_pic_name
|
varchar(200)
|
latin1_swedish_ci
|
|
|
|
event_pic_phone
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
event_instrument_status
|
INT
|
|
|
|
|
event_signed_file
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
event_signed_name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
event_institution_evaluation1_status
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_institution_evaluation1_update_date
|
datetime
|
|
|
|
|
event_institution_evaluation2_status
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_institution_evaluation2_update_date
|
datetime
|
|
|
|
|
event_surveior_evaluation_status
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_surveior_evaluation_update_date
|
datetime
|
|
|
|
|
event_order_id
|
varchar(3)
|
latin1_swedish_ci
|
|
|
|
event_operator_id
|
INT
|
|
|
|
|
event_insert_date
|
datetime
|
|
|
|
|
event_insert_by
|
char(6)
|
latin1_swedish_ci
|
|
|
|
event_update_date
|
datetime
|
|
|
|
|
event_update_by
|
char(6)
|
latin1_swedish_ci
|
|
|
|
event_delete_date
|
datetime
|
|
|
|
|
event_delete_by
|
char(6)
|
latin1_swedish_ci
|
|
|
|
event_record_status
|
char(1)
|
latin1_swedish_ci
|
|
|
|
event_survey_id
|
INT
|
|
|
|
