鉴定机构申报表 - Oracle SQL 表结构

CREATE TABLE g_institution_application ( g_name VARCHAR2(100), g_address VARCHAR2(200), g_office_area NUMBER(10), g_legal_representative VARCHAR2(100), g_contact_number VARCHAR2(20), g_business_license_number VARCHAR2(50), g_legal_representative_phone VARCHAR2(20), g_registration_date DATE, g_business_period_start DATE, g_business_period_end DATE, g_application_category VARCHAR2(50), g_qualification_registration VARCHAR2(50), g_qualification_type VARCHAR2(50), g_qualification_registration_date DATE, g_qualification_valid_period DATE, g_qualification_number VARCHAR2(50), g_registered_capital NUMBER(10), g_professional_liability_insurance NUMBER(10), g_insurance_expiry_date DATE, g_total_personnel NUMBER(10), g_professional_personnel_number NUMBER(10), g_senior_title_personnel_number NUMBER(10), g_intermediate_title_personnel_number NUMBER(10), g_other_personnel_number NUMBER(10), g_contact_person VARCHAR2(100), g_contact_person_phone VARCHAR2(20), g_recent_three_years_income_tax_payable NUMBER(10), g_recent_three_years_arbitration_total NUMBER(10), g_required_instruments_and_equipment VARCHAR2(200), g_honors_and_punishments VARCHAR2(200), g_business_capability_summary VARCHAR2(500) );

COMMENT ON TABLE g_institution_application IS '机构申报表';

COMMENT ON COLUMN g_institution_application.g_name IS '机构名称'; COMMENT ON COLUMN g_institution_application.g_address IS '机构地址'; COMMENT ON COLUMN g_institution_application.g_office_area IS '办公面积'; COMMENT ON COLUMN g_institution_application.g_legal_representative IS '法定代表人'; COMMENT ON COLUMN g_institution_application.g_contact_number IS '联系电话'; COMMENT ON COLUMN g_institution_application.g_business_license_number IS '营业执照注册号'; COMMENT ON COLUMN g_institution_application.g_legal_representative_phone IS '法定代表人的联系电话'; COMMENT ON COLUMN g_institution_application.g_registration_date IS '机构注册登记'; COMMENT ON COLUMN g_institution_application.g_business_period_start IS '营业期开始日期'; COMMENT ON COLUMN g_institution_application.g_business_period_end IS '营业期结束日期'; COMMENT ON COLUMN g_institution_application.g_application_category IS '申报机构类别'; COMMENT ON COLUMN g_institution_application.g_qualification_registration IS '资质/备案登记'; COMMENT ON COLUMN g_institution_application.g_qualification_type IS '资质/备案类型机构'; COMMENT ON COLUMN g_institution_application.g_qualification_registration_date IS '资质/备案登记日期'; COMMENT ON COLUMN g_institution_application.g_qualification_valid_period IS '资质/备案有效期限'; COMMENT ON COLUMN g_institution_application.g_qualification_number IS '资质/备案编号'; COMMENT ON COLUMN g_institution_application.g_registered_capital IS '机构注册资金'; COMMENT ON COLUMN g_institution_application.g_professional_liability_insurance IS '职业责任保险(万元)'; COMMENT ON COLUMN g_institution_application.g_insurance_expiry_date IS '购买年限'; COMMENT ON COLUMN g_institution_application.g_total_personnel IS '机构人员总数'; COMMENT ON COLUMN g_institution_application.g_professional_personnel_number IS '专业人员人数'; COMMENT ON COLUMN g_institution_application.g_senior_title_personnel_number IS '高级职称人数'; COMMENT ON COLUMN g_institution_application.g_intermediate_title_personnel_number IS '中级职称人数'; COMMENT ON COLUMN g_institution_application.g_other_personnel_number IS '其他人数'; COMMENT ON COLUMN g_institution_application.g_contact_person IS '联系人'; COMMENT ON COLUMN g_institution_application.g_contact_person_phone IS '联系电话'; COMMENT ON COLUMN g_institution_application.g_recent_three_years_income_tax_payable IS '近三年营业收入及纳税情况(万元)'; COMMENT ON COLUMN g_institution_application.g_recent_three_years_arbitration_total IS '近三年接收仲裁机构、法院委托总量'; COMMENT ON COLUMN g_institution_application.g_required_instruments_and_equipment IS '机构从事业务应具备的仪器设备情况'; COMMENT ON COLUMN g_institution_application.g_honors_and_punishments IS '机构所获表彰及处分情况'; COMMENT ON COLUMN g_institution_application.g_business_capability_summary IS '机构业务能力综述';