Tutorial Gadget Table¶
Tutorial Gadget Table Definition¶
Layout of tutorial gadget table [k99t_tutorial] is shown as below.
No. Logical name Physical name Type Length Mandatory PK 1 System matter ID system_matter_id varchar2 20 Y 1 2 User data ID user_data_id varchar2 20 Y 2 3 Gadget class gadget_class varchar2 100 Y 3 4 Gadget instance gadget_instance number 18,0 Y 4 5 Gadget ID gadget_id varchar2 220 Y 6 Gadget variation gadget_variation varchar2 100 Y 7 Text tutorial_text varchar2 1000 8 Currency code tutorial_currency_cd varchar2 100 9 Amount tutorial_amount number 28,10 10 Extension item A extension_a varchar2 1000 11 Extension item B extension_b varchar2 1000 12 Extension item C extension_c varchar2 1000 13 Extension item D extension_d varchar2 1000 14 Extension item E extension_e varchar2 1000 15 Extension item F extension_f varchar2 1000 16 Extension item G extension_g varchar2 1000 17 Extension item H extension_h varchar2 1000 18 Extension item I extension_i varchar2 1000 19 Extension item J extension_j varchar2 1000 20 Registration date and time entry_ts timestamp Y 21 Registrator code entry_user_cd varchar2 100 Y 22 Update counter renew_cnt number 18,0 Y 23 Update date and time renew_ts timestamp Y 24 Updator code renew_user_cd varchar2 100 Y Notes
Extension item A~J
It is a column that is commonly given to a table related to intra-mart Accel Kaiden! .It does not have to be given.Registration date and time, registrator code, update counter, update date and time, and updator code.
It is a column that is commonly given to a table related to intra-mart Accel Kaiden! .These columns must be given.
Tutorial Gadget Table Create Sentence (Oracle)¶
create table k99t_tutorial ( system_matter_id varchar2(20) not null, user_data_id varchar2(20) not null, gadget_class varchar2(100) not null, gadget_instance numeric(18,0) not null, gadget_id varchar2(220) not null, gadget_variation varchar2(100) not null, tutorial_text varchar2(1000), tutorial_currency_cd varchar2(100), tutorial_amount numeric(28,10), extension_a varchar2(1000), extension_b varchar2(1000), extension_c varchar2(1000), extension_d varchar2(1000), extension_e varchar2(1000), extension_f varchar2(1000), extension_g varchar2(1000), extension_h varchar2(1000), extension_i varchar2(1000), extension_j varchar2(1000), entry_ts timestamp not null, entry_user_cd varchar2(100) not null, renew_cnt numeric(18,0) not null, renew_ts timestamp not null, renew_user_cd varchar2(100) not null ); alter table k99t_tutorial add primary key (system_matter_id, user_data_id, gadget_class, gadget_instance); comment on table k99t_tutorial is 'tutorial gadget'; comment on column k99t_tutorial.system_matter_id is 'system matter ID'; comment on column k99t_tutorial.user_data_id is 'user data ID'; comment on column k99t_tutorial.gadget_class is 'gadget class'; comment on column k99t_tutorial.gadget_instance is 'gadget instance'; comment on column k99t_tutorial.gadget_id is 'gadget ID'; comment on column k99t_tutorial.gadget_variation is 'gadget variation'; comment on column k99t_tutorial.tutorial_text is 'text'; comment on column k99t_tutorial.tutorial_currency_cd is 'currency code'; comment on column k99t_tutorial.tutorial_amount is 'amount'; comment on column k99t_tutorial.extension_a is 'extension item a'; comment on column k99t_tutorial.extension_b is 'extension item b'; comment on column k99t_tutorial.extension_c is 'extension item c'; comment on column k99t_tutorial.extension_d is 'extension item d'; comment on column k99t_tutorial.extension_e is 'extension item e'; comment on column k99t_tutorial.extension_f is 'extension item f'; comment on column k99t_tutorial.extension_g is 'extension item g'; comment on column k99t_tutorial.extension_h is 'extension item h'; comment on column k99t_tutorial.extension_i is 'extension item i'; comment on column k99t_tutorial.extension_j is 'extension item j'; comment on column k99t_tutorial.entry_ts is 'registration date'; comment on column k99t_tutorial.entry_user_cd is 'registrator'; comment on column k99t_tutorial.renew_cnt is 'update counter'; comment on column k99t_tutorial.renew_ts is 'update date'; comment on column k99t_tutorial.renew_user_cd is 'updator';Notes
About mandatory input item,In this tutorial, [Text] is to be optional input item and [Amount] is to be mandatory input item but NotNull limitation is not set to [Amount].Please refer to Application Form Gadget Field Group Master.