dashDB - Creating a table with CLOB column type

TABLE m_pi_error; CREATE TABLE m_pi_error ( id INTEGER NOT NULL, customer_id VARCHAR(15), twitter_id VARCHAR(255), err_msg clob(5M), create_time date, PRIMARY KEY(id) ) ORGANIZE BY ROW; DROP TABLE m_pi_note; CREATE TABLE m_pi_note ( id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), customer_id VARCHAR(15), twitter_id VARCHAR(255), personal_note clob(5M), create_time date, PRIMARY KEY(id) )ORGANIZE BY ROW; DROP TABLE m_pi_values; CREATE TABLE m_pi_values ( CUSTOMER_ID varchar(30) DEFAULT NULL, TWITTER_ID varchar(30) DEFAULT NULL, word_count double DEFAULT NULL, processed_language varchar(30) DEFAULT NULL, big5_openness double DEFAULT NULL, facet_adventurousness double DEFAULT NULL, facet_artistic_interests double DEFAULT NULL, facet_emotionality double DEFAULT NULL, facet_imagination double DEFAULT NULL, facet_intellect double DEFAULT NULL, facet_liberalism double DEFAULT NULL, big5_conscientiousness double DEFAULT NULL, facet_achievement_striving double DEFAULT NULL, facet_cautiousness double DEFAULT NULL, facet_dutifulness double DEFAULT NULL, facet_orderliness double DEFAULT NULL, facet_self_discipline double DEFAULT NULL, facet_self_efficacy double DEFAULT NULL, big5_extraversion double DEFAULT NULL, facet_activity_level double DEFAULT NULL, facet_assertiveness double DEFAULT NULL, facet_cheerfulness double DEFAULT NULL, facet_excitement_seeking double DEFAULT NULL, facet_friendliness double DEFAULT NULL, facet_gregariousness double DEFAULT NULL, big5_agreeableness double DEFAULT NULL, facet_altruism double DEFAULT NULL, facet_cooperation double DEFAULT NULL, facet_modesty double DEFAULT NULL, facet_morality double DEFAULT NULL, facet_sympathy double DEFAULT NULL, facet_trust double DEFAULT NULL, big5_neuroticism double DEFAULT NULL, facet_anger double DEFAULT NULL, facet_anxiety double DEFAULT NULL, facet_depression double DEFAULT NULL, facet_immoderation double DEFAULT NULL, facet_self_consciousness double DEFAULT NULL, facet_vulnerability double DEFAULT NULL, need_challenge double DEFAULT NULL, need_closeness double DEFAULT NULL, need_curiosity double DEFAULT NULL, need_excitement double DEFAULT NULL, need_harmony double DEFAULT NULL, need_ideal double DEFAULT NULL, need_liberty double DEFAULT NULL, need_love double DEFAULT NULL, need_practicality double DEFAULT NULL, need_self_expression double DEFAULT NULL, need_stability double DEFAULT NULL, need_structure double DEFAULT NULL, value_conservation double DEFAULT NULL, value_hedonism double DEFAULT NULL, value_openness_to_change double DEFAULT NULL, value_self_enhancement double DEFAULT NULL, value_self_transcendence double DEFAULT NULL, behavior_sunday double DEFAULT NULL, behavior_monday double DEFAULT NULL, behavior_tuesday double DEFAULT NULL, behavior_wednesday double DEFAULT NULL, behavior_thursday double DEFAULT NULL, behavior_friday double DEFAULT NULL, behavior_saturday double DEFAULT NULL, behavior_0000 double DEFAULT NULL, behavior_0100 double DEFAULT NULL, behavior_0200 double DEFAULT NULL, behavior_0300 double DEFAULT NULL, behavior_0400 double DEFAULT NULL, behavior_0500 double DEFAULT NULL, behavior_0600 double DEFAULT NULL, behavior_0700 double DEFAULT NULL, behavior_0800 double DEFAULT NULL, behavior_0900 double DEFAULT NULL, behavior_1000 double DEFAULT NULL, behavior_1100 double DEFAULT NULL, behavior_1200 double DEFAULT NULL, behavior_1300 double DEFAULT NULL, behavior_1400 double DEFAULT NULL, behavior_1500 double DEFAULT NULL, behavior_1600 double DEFAULT NULL, behavior_1700 double DEFAULT NULL, behavior_1800 double DEFAULT NULL, behavior_1900 double DEFAULT NULL, behavior_2000 double DEFAULT NULL, behavior_2100 double DEFAULT NULL, behavior_2200 double DEFAULT NULL, behavior_2300 double DEFAULT NULL, cp_automobile_ownership_cost double DEFAULT NULL, cp_automobile_safety double DEFAULT NULL, cp_clothes_quality double DEFAULT NULL, cp_clothes_style double DEFAULT NULL, cp_clothes_comfort double DEFAULT NULL, cp_influence_brand_name double DEFAULT NULL, cp_influence_utility double DEFAULT NULL, cp_influence_online_ads double DEFAULT NULL, cp_influence_social_media double DEFAULT NULL, cp_influence_family_members double DEFAULT NULL, cp_spur_of_moment double DEFAULT NULL, cp_credit_card_payment double DEFAULT NULL, cp_eat_out double DEFAULT NULL, cp_gym_membership double DEFAULT NULL, cp_outdoor double DEFAULT NULL, cp_concerned_environment double DEFAULT NULL, cp_start_business double DEFAULT NULL, cp_movie_romance double DEFAULT NULL, cp_movie_adventure double DEFAULT NULL, cp_movie_horror double DEFAULT NULL, cp_movie_musical double DEFAULT NULL, cp_movie_historical double DEFAULT NULL, cp_movie_science_fiction double DEFAULT NULL, cp_movie_war double DEFAULT NULL, cp_movie_drama double DEFAULT NULL, cp_movie_action double DEFAULT NULL, cp_movie_documentary double DEFAULT NULL, cp_music_rap double DEFAULT NULL, cp_music_country double DEFAULT NULL, cp_music_r_b double DEFAULT NULL, cp_music_hip_hop double DEFAULT NULL, cp_music_live_event double DEFAULT NULL, cp_music_playing double DEFAULT NULL, cp_music_latin double DEFAULT NULL, cp_music_rock double DEFAULT NULL, cp_music_classical double DEFAULT NULL, cp_read_frequency double DEFAULT NULL, cp_books_entertainment_mag double DEFAULT NULL, cp_books_non_fiction double DEFAULT NULL, cp_books_financial_investing double DEFAULT NULL, cp_books_autobiographies double DEFAULT NULL, cp_volunteer double DEFAULT NULL ); DROP TABLE m_twitter_error; CREATE TABLE m_twitter_error ( id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), customer_id varchar(15) DEFAULT NULL, twitter_id varchar(255) DEFAULT NULL, err_msg clob(5M), create_time date DEFAULT NULL, PRIMARY KEY (id) ) ORGANIZE BY ROW; DROP TABLE m_twitter_note; CREATE TABLE m_twitter_note ( id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), customer_id varchar(15), twitter_id varchar(255), twitter_note clob(5M), create_time date DEFAULT NULL, PRIMARY KEY (id) ) ORGANIZE BY ROW;

 

 

dashDB - Creating a table with CLOB column type

标签：family   table   int   util   mem   blog   read   incr   extra