create_types.sql

prompt create_types.sql
-- types used by clicksend 0.2

create type t_clicksend_msg is object
  ( message_type  varchar2(20) -- sms, mms, voice
  , requested_ts  timestamp
  , schedule_dt   date
  , sender        varchar2(20)
  , recipient     varchar2(20)
  , subject       varchar2(4000) -- for mms
  , message       varchar2(4000)
  , media_file    varchar2(4000) -- for mms
  , voice_lang    varchar2(100) -- for voice: e.g. en-us, en-au, en-gb
  , voice_gender  varchar2(6) -- for voice: female or male
  , country       varchar2(10 char)
  , reply_email   varchar2(255 char)
  , custom_string varchar2(4000)
  );
/

create type t_clicksend_lang is object
  (lang_code    varchar2(10)
  ,country_desc varchar2(100)
  ,female       varchar2(1)
  ,male         varchar2(1)
  );
/

create type t_clicksend_lang_arr is table of t_clicksend_lang;

create type t_clicksend_country is object
  (country_code varchar2(10)
  ,country_name varchar2(100)
  );
/

create type t_clicksend_country_arr is table of t_clicksend_country;

create type t_clicksend_sms_history is object
  (event_dt      date
  ,mobile        varchar2(20)
  ,message       varchar2(4000)
  ,status        varchar2(100)
  ,sender        varchar2(100)
  ,schedule_dt   date
  ,status_code   varchar2(100)
  ,status_text   varchar2(4000)
  ,error_code    varchar2(100)
  ,error_text    varchar2(4000)
  ,message_id    varchar2(4000)
  ,message_parts number
  ,message_price number
  ,reply_email   varchar2(255)
  ,custom_string varchar2(4000)
  ,subaccount_id number
  ,country       varchar2(10)
  ,carrier       varchar2(100)
  );
/

create type t_clicksend_sms_history_arr is table of t_clicksend_sms_history;