source: branches/feature-module-update/html/install/sql/create_table_oracle.sql @ 15528

Revision 15528, 24.7 KB checked in by nanasess, 17 years ago (diff)

FIXME 暫定 commit
RevLine 
[15528]1--
2-- FIXME 要修正
3--
4
5CREATE TABLE dtb_kiyaku (
6    kiyaku_id number(9) NOT NULL,
7    kiyaku_title varchar2(4000) NOT NULL,
8    kiyaku_text varchar2(4000) NOT NULL,
9    rank number(9) NOT NULL ,
10    creator_id number(9) NOT NULL,
11    create_date timestamp NOT NULL ,
12    update_date timestamp NOT NULL,
13    del_flg  number(4) NOT NULL
14);
15
16CREATE TABLE mtb_zip (
17    code varchar2(4000),
18    old_zipcode varchar2(4000),
19    zipcode varchar2(4000),
20    state_kana varchar2(4000),
21    city_kana varchar2(4000),
22    town_kana varchar2(4000),
23    state varchar2(4000),
24    city varchar2(4000),
25    town varchar2(4000),
26    flg1 varchar2(4000),
27    flg2 varchar2(4000),
28    flg3 varchar2(4000),
29    flg4 varchar2(4000),
30    flg5 varchar2(4000),
31    flg6 varchar2(4000)
32);
33
34CREATE TABLE dtb_bat_order_daily_age (
35    order_count number(9) NOT NULL ,
36    total number(9) NOT NULL ,
37    total_average number(9) NOT NULL ,
38    start_age number(4),
39    end_age number(4),
40    member number(4),
41    order_date timestamp ,
42    create_date timestamp NOT NULL
43);
44
45CREATE TABLE dtb_update (
46    module_id number(9) NOT NULL UNIQUE,
47    module_name varchar2(4000) NOT NULL,
48    now_version varchar2(4000),
49    latest_version varchar2(4000) NOT NULL,
50    module_explain varchar2(4000),
51    main_php varchar2(4000) NOT NULL,
52    extern_php varchar2(4000) NOT NULL,
53    install_sql varchar2(4000),
54    uninstall_sql varchar2(4000),
55    other_files varchar2(4000),
56    del_flg number(4) NOT NULL ,
57    create_date timestamp NOT NULL ,
58    update_date timestamp,
59    release_date timestamp NOT NULL
60);
61
62CREATE TABLE dtb_baseinfo (
63    company_name varchar2(4000),
64    company_kana varchar2(4000),
65    zip01 varchar2(4000),
66    zip02 varchar2(4000),
67    pref number(4),
68    addr01 varchar2(4000),
69    addr02 varchar2(4000),
70    tel01 varchar2(4000),
71    tel02 varchar2(4000),
72    tel03 varchar2(4000),
73    fax01 varchar2(4000),
74    fax02 varchar2(4000),
75    fax03 varchar2(4000),
76    business_hour varchar2(4000),
77    law_company varchar2(4000),
78    law_manager varchar2(4000),
79    law_zip01 varchar2(4000),
80    law_zip02 varchar2(4000),
81    law_pref number(4),
82    law_addr01 varchar2(4000),
83    law_addr02 varchar2(4000),
84    law_tel01 varchar2(4000),
85    law_tel02 varchar2(4000),
86    law_tel03 varchar2(4000),
87    law_fax01 varchar2(4000),
88    law_fax02 varchar2(4000),
89    law_fax03 varchar2(4000),
90    law_email varchar2(4000),
91    law_url varchar2(4000),
92    law_term01 varchar2(4000),
93    law_term02 varchar2(4000),
94    law_term03 varchar2(4000),
95    law_term04 varchar2(4000),
96    law_term05 varchar2(4000),
97    law_term06 varchar2(4000),
98    law_term07 varchar2(4000),
99    law_term08 varchar2(4000),
100    law_term09 varchar2(4000),
101    law_term10 varchar2(4000),
102    tax number(9) ,
103    tax_rule number(4) ,
104    email01 varchar2(4000),
105    email02 varchar2(4000),
106    email03 varchar2(4000),
107    email04 varchar2(4000),
108    email05 varchar2(4000),
109    free_rule number(9),
110    shop_name varchar2(4000),
111    shop_kana varchar2(4000),
112    point_rate number(9),
113    welcome_point number(9),
114    update_date timestamp,
115    top_tpl varchar2(4000),
116    product_tpl varchar2(4000),
117    detail_tpl varchar2(4000),
118    mypage_tpl varchar2(4000),
119    good_traded varchar2(4000),
120    message varchar2(4000)
121);
122
123CREATE TABLE dtb_deliv (
124    deliv_id number(9) NOT NULL,
125    name varchar2(4000),
126    service_name varchar2(4000),
127    confirm_url varchar2(4000),
128    rank number(9),
129    status number(4) NOT NULL ,
130    del_flg number(4) NOT NULL ,
131    creator_id number(9) NOT NULL,
132    create_date timestamp NOT NULL ,
133    update_date timestamp
134);
135
136CREATE TABLE dtb_delivtime (
137    deliv_id number(9) NOT NULL,
138    time_id number(9) NOT NULL,
139    deliv_time varchar2(4000) NOT NULL
140);
141
142CREATE TABLE dtb_delivfee (
143    deliv_id number(9) NOT NULL,
144    fee_id number(9) NOT NULL,
145    fee varchar2(4000) NOT NULL,
146    pref number(4)
147);
148
149CREATE TABLE dtb_payment (
150    payment_id number(9) NOT NULL,
151    payment_method varchar2(4000),
152    charge number(9),
153    rule number(9),
154    deliv_id number(9) ,
155    rank number(9),
156    note varchar2(4000),
157    fix number(4),
158    status number(4) NOT NULL ,
159    del_flg number(4) NOT NULL ,
160    creator_id number(9) NOT NULL,
161    create_date timestamp NOT NULL ,
162    update_date timestamp,
163    payment_image varchar2(4000),
164    upper_rule number(9),
165    charge_flg number(4) ,
166    rule_min number(9),
167    upper_rule_max number(9),
168    module_id number(9),
169    module_path varchar2(4000),
170    memo01 varchar2(4000),
171    memo02 varchar2(4000),
172    memo03 varchar2(4000),
173    memo04 varchar2(4000),
174    memo05 varchar2(4000),
175    memo06 varchar2(4000),
176    memo07 varchar2(4000),
177    memo08 varchar2(4000),
178    memo09 varchar2(4000),
179    memo10 varchar2(4000)
180);
181
182CREATE TABLE dtb_mailtemplate (
183    template_id number(9) NOT NULL,
184    subject varchar2(4000),
185    header varchar2(4000),
186    footer varchar2(4000),
187    creator_id number(9) NOT NULL,
188    del_flg number(4) NOT NULL ,
189    create_date timestamp NOT NULL ,
190    update_date timestamp NOT NULL
191);
192
193CREATE TABLE dtb_mailmaga_template (
194    template_id number(9) NOT NULL UNIQUE,
195    subject varchar2(4000),
196    charge_image varchar2(4000),
197    mail_method number(9),
198    header varchar2(4000),
199    body varchar2(4000),
200    main_title varchar2(4000),
201    main_comment varchar2(4000),
202    main_product_id number(9),
203    sub_title varchar2(4000),
204    sub_comment varchar2(4000),
205    sub_product_id01 number(9),
206    sub_product_id02 number(9),
207    sub_product_id03 number(9),
208    sub_product_id04 number(9),
209    sub_product_id05 number(9),
210    sub_product_id06 number(9),
211    sub_product_id07 number(9),
212    sub_product_id08 number(9),
213    sub_product_id09 number(9),
214    sub_product_id10 number(9),
215    sub_product_id11 number(9),
216    sub_product_id12 number(9),
217    del_flg number(4) NOT NULL ,
218    creator_id number(9) NOT NULL,
219    create_date timestamp NOT NULL ,
220    update_date timestamp
221);
222
223CREATE TABLE dtb_send_history (
224    send_id number(9) NOT NULL,
225    mail_method number(4),
226    subject varchar2(4000),
227    body varchar2(4000),
228    send_count number(9),
229    complete_count number(9) NOT NULL ,
230    start_date timestamp,
231    end_date timestamp,
232    search_data varchar2(4000),
233    del_flg number(4) NOT NULL ,
234    creator_id number(9) NOT NULL,
235    create_date timestamp NOT NULL ,
236    update_date timestamp NOT NULL
237);
238
239CREATE TABLE dtb_send_customer (
240    customer_id number(9),
241    send_id number(9) NOT NULL,
242    email varchar2(4000),
243    name varchar2(4000),
244    send_flag number(4)
245);
246
247CREATE TABLE dtb_products (
248    product_id number(9) NOT NULL UNIQUE,
249    name varchar2(4000),
250    deliv_fee number(9),
251    sale_limit number(9),
252    sale_unlimited number(4) ,
253    category_id number(9),
254    rank number(9),
255    status number(4) NOT NULL ,
256    product_flag varchar2(4000),
257    point_rate number(9),
258    comment1 varchar2(4000),
259    comment2 varchar2(4000),
260    comment3 varchar2(4000),
261    comment4 varchar2(4000),
262    comment5 varchar2(4000),
263    comment6 varchar2(4000),
264    file1 varchar2(4000),
265    file2 varchar2(4000),
266    file3 varchar2(4000),
267    file4 varchar2(4000),
268    file5 varchar2(4000),
269    file6 varchar2(4000),
270    main_list_comment varchar2(4000),
271    main_list_image varchar2(4000),
272    main_comment varchar2(4000),
273    main_image varchar2(4000),
274    main_large_image varchar2(4000),
275    sub_title1 varchar2(4000),
276    sub_comment1 varchar2(4000),
277    sub_image1 varchar2(4000),
278    sub_large_image1 varchar2(4000),
279    sub_title2 varchar2(4000),
280    sub_comment2 varchar2(4000),
281    sub_image2 varchar2(4000),
282    sub_large_image2 varchar2(4000),
283    sub_title3 varchar2(4000),
284    sub_comment3 varchar2(4000),
285    sub_image3 varchar2(4000),
286    sub_large_image3 varchar2(4000),
287    sub_title4 varchar2(4000),
288    sub_comment4 varchar2(4000),
289    sub_image4 varchar2(4000),
290    sub_large_image4 varchar2(4000),
291    sub_title5 varchar2(4000),
292    sub_comment5 varchar2(4000),
293    sub_image5 varchar2(4000),
294    sub_large_image5 varchar2(4000),
295    sub_title6 varchar2(4000),
296    sub_comment6 varchar2(4000),
297    sub_image6 varchar2(4000),
298    sub_large_image6 varchar2(4000),
299    del_flg number(4) NOT NULL ,
300    creator_id number(9) NOT NULL,
301    create_date timestamp NOT NULL ,
302    update_date timestamp,
303    deliv_date_id number(9)
304);
305
306CREATE TABLE dtb_products_class (
307    product_class_id number(9) NOT NULL UNIQUE,
308    product_id number(9) NOT NULL,
309    classcategory_id1 number(9) NOT NULL ,
310    classcategory_id2 number(9) NOT NULL ,
311    product_code varchar2(4000),
312    stock number(9),
313    stock_unlimited number(4) ,
314    sale_limit number(9),
315    price01 number(9),
316    price02 number(9),
317    status number(4),
318    creator_id number(9) NOT NULL,
319    create_date timestamp NOT NULL ,
320    update_date timestamp
321);
322
323CREATE TABLE dtb_class (
324    class_id number(9) NOT NULL,
325    name varchar2(4000),
326    status number(4),
327    rank number(9),
328    creator_id number(9) NOT NULL,
329    create_date timestamp NOT NULL ,
330    update_date timestamp,
331    del_flg  number(4) NOT NULL ,
332    product_id number(9)
333);
334
335CREATE TABLE dtb_classcategory (
336    classcategory_id number(9) NOT NULL,
337    name varchar2(4000),
338    class_id number(9) NOT NULL,
339    status number(4),
340    rank number(9),
341    creator_id number(9) NOT NULL,
342    create_date timestamp NOT NULL ,
343    update_date timestamp,
344    del_flg  number(4) NOT NULL
345);
346
347CREATE TABLE dtb_category (
348    category_id number(9) NOT NULL,
349    category_name varchar2(4000),
350    parent_category_id number(9) NOT NULL ,
351    category_level number(9) NOT NULL,
352    rank number(9),
353    creator_id number(9) NOT NULL,
354    create_date timestamp NOT NULL ,
355    update_date timestamp,
356    del_flg  number(4) NOT NULL
357);
358
359
360CREATE TABLE dtb_bat_order_daily (
361    total_order number(9) NOT NULL ,
362    member number(9) NOT NULL ,
363    nonmember number(9) NOT NULL ,
364    men number(9) NOT NULL ,
365    women number(9) NOT NULL ,
366    men_member number(9) NOT NULL ,
367    men_nonmember number(9) NOT NULL ,
368    women_member number(9) NOT NULL ,
369    women_nonmember number(9) NOT NULL ,
370    total number(9) NOT NULL ,
371    total_average number(9) NOT NULL ,
372    order_date timestamp NOT NULL ,
373    create_date timestamp NOT NULL ,
374    year number(4) NOT NULL,
375    month number(4) NOT NULL,
376    day number(4) NOT NULL,
377    wday number(4) NOT NULL,
378    key_day varchar2(4000) NOT NULL,
379    key_month varchar2(4000) NOT NULL,
380    key_year varchar2(4000) NOT NULL,
381    key_wday varchar2(4000) NOT NULL
382);
383
384CREATE TABLE dtb_bat_order_daily_hour (
385    total_order number(9) NOT NULL ,
386    member number(9) NOT NULL ,
387    nonmember number(9) NOT NULL ,
388    men number(9) NOT NULL ,
389    women number(9) NOT NULL ,
390    men_member number(9) NOT NULL ,
391    men_nonmember number(9) NOT NULL ,
392    women_member number(9) NOT NULL ,
393    women_nonmember number(9) NOT NULL ,
394    total number(9) NOT NULL ,
395    total_average number(9) NOT NULL ,
396    hour number(4) NOT NULL ,
397    order_date timestamp ,
398    create_date timestamp NOT NULL
399);
400
401CREATE TABLE dtb_recommend_products (
402    product_id number(9) NOT NULL,
403    recommend_product_id number(9) NOT NULL,
404    rank number(9) NOT NULL,
405    recommend_product_comment varchar2(4000),
406    status number(4) NOT NULL ,
407    creator_id number(9) NOT NULL,
408    create_date timestamp NOT NULL ,
409    update_date timestamp NOT NULL
410);
411
412CREATE TABLE dtb_review (
413    review_id number(9) NOT NULL,
414    product_id number(9) NOT NULL,
415    reviewer_name varchar2(4000) NOT NULL,
416    reviewer_url varchar2(4000),
417    sex number(4),
418    customer_id number(9),
419    recommend_level number(4) NOT NULL,
420    title varchar2(4000) NOT NULL,
421    review_comment varchar2(4000) NOT NULL,
422    status number(4) ,
423    creator_id number(9) NOT NULL,
424    create_date timestamp NOT NULL ,
425    update_date timestamp,
426    del_flg  number(4) NOT NULL
427);
428
429CREATE TABLE dtb_customer_reading (
430    reading_product_id number(9) NOT NULL,
431    customer_id number(9) NOT NULL,
432    create_date timestamp NOT NULL,
433    update_date timestamp NOT NULL
434);
435
436CREATE TABLE dtb_category_count (
437    category_id number(9) NOT NULL,
438    product_count number(9) NOT NULL,
439    create_date timestamp NOT NULL
440);
441
442CREATE TABLE dtb_category_total_count (
443    category_id number(9) NOT NULL,
444    product_count number(9),
445    create_date timestamp NOT NULL
446);
447
448CREATE TABLE dtb_news (
449    news_id number(9) NOT NULL UNIQUE,
450    news_date timestamp,
451    rank number(9),
452    news_title varchar2(4000) NOT NULL,
453    news_comment varchar2(4000),
454    news_url varchar2(4000),
455    news_select number(4) NOT NULL ,
456    link_method varchar2(4000),
457    creator_id number(9) NOT NULL,
458    create_date timestamp NOT NULL ,
459    update_date timestamp,
460    del_flg  number(4) NOT NULL
461);
462
463CREATE TABLE dtb_best_products (
464    best_id number(9) NOT NULL,
465    category_id number(9) NOT NULL,
466    rank number(9) NOT NULL ,
467    product_id number(9) NOT NULL,
468    title varchar2(4000),
469    product_comment varchar2(4000),
470    creator_id number(9) NOT NULL,
471    create_date timestamp NOT NULL ,
472    update_date timestamp,
473    del_flg  number(4) NOT NULL
474);
475
476CREATE TABLE dtb_mail_history (
477    send_id number(9)  NOT NULL,
478    order_id number(9) NOT NULL,
479    send_date timestamp,
480    template_id number(9),
481    creator_id number(9) NOT NULL,
482    subject varchar2(4000),
483    mail_body varchar2(4000)
484);
485
486CREATE TABLE dtb_customer (
487    customer_id number(9)  NOT NULL,
488    name01 varchar2(4000) NOT NULL,
489    name02 varchar2(4000) NOT NULL,
490    kana01 varchar2(4000) NOT NULL,
491    kana02 varchar2(4000) NOT NULL,
492    zip01 varchar2(4000),
493    zip02 varchar2(4000),
494    pref number(4),
495    addr01 varchar2(4000),
496    addr02 varchar2(4000),
497    email varchar2(4000) NOT NULL,
498    email_mobile varchar2(4000),
499    tel01 varchar2(4000),
500    tel02 varchar2(4000),
501    tel03 varchar2(4000),
502    fax01 varchar2(4000),
503    fax02 varchar2(4000),
504    fax03 varchar2(4000),
505    sex number(4),
506    job number(4),
507    birth timestamp,
508    password varchar2(4000),
509    reminder number(4),
510    reminder_answer varchar2(4000),
511    secret_key varchar2(4000) NOT NULL UNIQUE,
512    first_buy_date timestamp,
513    last_buy_date timestamp,
514    buy_times number(9) ,
515    buy_total number(9) ,
516    point number(9) ,
517    note varchar2(4000),
518    status number(4) NOT NULL ,
519    create_date timestamp NOT NULL ,
520    update_date timestamp ,
521    del_flg  number(4) NOT NULL ,
522    cell01 varchar2(4000),
523    cell02 varchar2(4000),
524    cell03 varchar2(4000),
525    mobile_phone_id varchar2(4000),
526    mailmaga_flg number(4)
527);
528
529-- CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);
530
531CREATE TABLE dtb_customer_mail_temp (
532    email varchar2(4000) NOT NULL UNIQUE,
533    mail_flag number(4),
534    temp_id varchar2(4000) NOT NULL UNIQUE,
535    end_flag number(4),
536    update_date timestamp NOT NULL ,
537    create_data timestamp NOT NULL
538);
539
540CREATE TABLE dtb_order (
541    order_id number(9) NOT NULL,
542    order_temp_id varchar2(4000),
543    customer_id number(9) NOT NULL,
544    message varchar2(4000),
545    order_name01 varchar2(4000),
546    order_name02 varchar2(4000),
547    order_kana01 varchar2(4000),
548    order_kana02 varchar2(4000),
549    order_email varchar2(4000),
550    order_tel01 varchar2(4000),
551    order_tel02 varchar2(4000),
552    order_tel03 varchar2(4000),
553    order_fax01 varchar2(4000),
554    order_fax02 varchar2(4000),
555    order_fax03 varchar2(4000),
556    order_zip01 varchar2(4000),
557    order_zip02 varchar2(4000),
558    order_pref varchar2(4000),
559    order_addr01 varchar2(4000),
560    order_addr02 varchar2(4000),
561    order_sex number(4),
562    order_birth timestamp,
563    order_job number(9),
564    deliv_name01 varchar2(4000),
565    deliv_name02 varchar2(4000),
566    deliv_kana01 varchar2(4000),
567    deliv_kana02 varchar2(4000),
568    deliv_tel01 varchar2(4000),
569    deliv_tel02 varchar2(4000),
570    deliv_tel03 varchar2(4000),
571    deliv_fax01 varchar2(4000),
572    deliv_fax02 varchar2(4000),
573    deliv_fax03 varchar2(4000),
574    deliv_zip01 varchar2(4000),
575    deliv_zip02 varchar2(4000),
576    deliv_pref varchar2(4000),
577    deliv_addr01 varchar2(4000),
578    deliv_addr02 varchar2(4000),
579    subtotal number(9),
580    discount number(9),
581    deliv_fee number(9),
582    charge number(9),
583    use_point number(9),
584    add_point number(9),
585    birth_point number(9) ,
586    tax number(9),
587    total number(9),
588    payment_total number(9),
589    payment_id number(9),
590    payment_method varchar2(4000),
591    deliv_id number(9),
592    deliv_time_id number(9),
593    deliv_time varchar2(4000),
594    deliv_no varchar2(4000),
595    note varchar2(4000),
596    status number(4),
597    create_date timestamp NOT NULL ,
598    loan_result varchar2(4000),
599    credit_result varchar2(4000),
600    credit_msg varchar2(4000),
601    update_date timestamp,
602    commit_date timestamp,
603    del_flg  number(4) NOT NULL ,
604    deliv_date varchar2(4000),
605    conveni_data varchar2(4000),
606    cell01 varchar2(4000),
607    cell02 varchar2(4000),
608    cell03 varchar2(4000),
609    memo01 varchar2(4000),
610    memo02 varchar2(4000),
611    memo03 varchar2(4000),
612    memo04 varchar2(4000),
613    memo05 varchar2(4000),
614    memo06 varchar2(4000),
615    memo07 varchar2(4000),
616    memo08 varchar2(4000),
617    memo09 varchar2(4000),
618    memo10 varchar2(4000),
619    campaign_id number(9)
620);
621
622CREATE TABLE dtb_order_temp (
623    order_temp_id varchar2(4000) NOT NULL,
624    customer_id number(9) NOT NULL,
625    message varchar2(4000),
626    order_name01 varchar2(4000),
627    order_name02 varchar2(4000),
628    order_kana01 varchar2(4000),
629    order_kana02 varchar2(4000),
630    order_email varchar2(4000),
631    order_tel01 varchar2(4000),
632    order_tel02 varchar2(4000),
633    order_tel03 varchar2(4000),
634    order_fax01 varchar2(4000),
635    order_fax02 varchar2(4000),
636    order_fax03 varchar2(4000),
637    order_zip01 varchar2(4000),
638    order_zip02 varchar2(4000),
639    order_pref varchar2(4000),
640    order_addr01 varchar2(4000),
641    order_addr02 varchar2(4000),
642    order_sex number(4),
643    order_birth timestamp,
644    order_job number(9),
645    deliv_name01 varchar2(4000),
646    deliv_name02 varchar2(4000),
647    deliv_kana01 varchar2(4000),
648    deliv_kana02 varchar2(4000),
649    deliv_tel01 varchar2(4000),
650    deliv_tel02 varchar2(4000),
651    deliv_tel03 varchar2(4000),
652    deliv_fax01 varchar2(4000),
653    deliv_fax02 varchar2(4000),
654    deliv_fax03 varchar2(4000),
655    deliv_zip01 varchar2(4000),
656    deliv_zip02 varchar2(4000),
657    deliv_pref varchar2(4000),
658    deliv_addr01 varchar2(4000),
659    deliv_addr02 varchar2(4000),
660    subtotal number(9),
661    discount number(9),
662    deliv_fee number(9),
663    charge number(9),
664    use_point number(9),
665    add_point number(9),
666    birth_point number(9) ,
667    tax number(9),
668    total number(9),
669    payment_total number(9),
670    payment_id number(9),
671    payment_method varchar2(4000),
672    deliv_id number(9),
673    deliv_time_id number(9),
674    deliv_time varchar2(4000),
675    deliv_no varchar2(4000),
676    note varchar2(4000),
677    mail_flag number(4),
678    status number(4),
679    deliv_check number(4),
680    point_check number(4),
681    loan_result varchar2(4000),
682    credit_result varchar2(4000),
683    credit_msg varchar2(4000),
684    create_date timestamp NOT NULL ,
685    update_date timestamp,
686    del_flg  number(4) NOT NULL ,
687    deliv_date varchar2(4000),
688    conveni_data varchar2(4000),
689    cell01 varchar2(4000),
690    cell02 varchar2(4000),
691    cell03 varchar2(4000),
692    order_id number(9),
693    memo01 varchar2(4000),
694    memo02 varchar2(4000),
695    memo03 varchar2(4000),
696    memo04 varchar2(4000),
697    memo05 varchar2(4000),
698    memo06 varchar2(4000),
699    memo07 varchar2(4000),
700    memo08 varchar2(4000),
701    memo09 varchar2(4000),
702    memo10 varchar2(4000),
703    order_session varchar2(4000)
704);
705
706CREATE TABLE dtb_other_deliv (
707    other_deliv_id number(9) NOT NULL,
708    customer_id number(9) NOT NULL,
709    name01 varchar2(4000),
710    name02 varchar2(4000),
711    kana01 varchar2(4000),
712    kana02 varchar2(4000),
713    zip01 varchar2(4000),
714    zip02 varchar2(4000),
715    pref varchar2(4000),
716    addr01 varchar2(4000),
717    addr02 varchar2(4000),
718    tel01 varchar2(4000),
719    tel02 varchar2(4000),
720    tel03 varchar2(4000)
721);
722
723CREATE TABLE dtb_order_detail (
724    order_id number(9) NOT NULL,
725    product_id number(9) NOT NULL,
726    classcategory_id1 number(9) NOT NULL,
727    classcategory_id2 number(9) NOT NULL,
728    product_name varchar2(4000) NOT NULL,
729    product_code varchar2(4000),
730    classcategory_name1 varchar2(4000),
731    classcategory_name2 varchar2(4000),
732    price number(9),
733    quantity number(9),
734    point_rate number(9)
735);
736
737CREATE TABLE mtb_pref (
738    pref_id number(4) NOT NULL,
739    pref_name varchar2(4000),
740    rank number(4) NOT NULL ,
741    PRIMARY KEY (pref_id)
742);
743
744CREATE TABLE dtb_member (
745    member_id number(9) NOT NULL,
746    name varchar2(4000),
747    department varchar2(4000),
748    login_id varchar2(4000) NOT NULL,
749    password varchar2(4000) NOT NULL,
750    authority number(4) NOT NULL,
751    rank number(9) NOT NULL ,
752    work number(4) NOT NULL ,
753    del_flg number(4) NOT NULL ,
754    creator_id number(9) NOT NULL,
755    update_date timestamp,
756    create_date timestamp NOT NULL ,
757    login_date timestamp
758);
759
760CREATE TABLE dtb_question (
761    question_id number(9) NOT NULL,
762    question_name varchar2(4000),
763    question varchar2(4000),
764    create_date timestamp NOT NULL ,
765    del_flg  number(4) NOT NULL
766);
767
768CREATE TABLE dtb_question_result (
769    result_id number(9) NOT NULL,
770    question_id number(9) NOT NULL,
771    question_date timestamp,
772    question_name varchar2(4000),
773    name01 varchar2(4000),
774    name02 varchar2(4000),
775    kana01 varchar2(4000),
776    kana02 varchar2(4000),
777    zip01 varchar2(4000),
778    zip02 varchar2(4000),
779    pref number(4),
780    addr01 varchar2(4000),
781    addr02 varchar2(4000),
782    tel01 varchar2(4000),
783    tel02 varchar2(4000),
784    tel03 varchar2(4000),
785    mail01 varchar2(4000),
786    question01 varchar2(4000),
787    question02 varchar2(4000),
788    question03 varchar2(4000),
789    question04 varchar2(4000),
790    question05 varchar2(4000),
791    question06 varchar2(4000),
792    create_date timestamp NOT NULL ,
793    del_flg  number(4) NOT NULL
794);
795
796CREATE TABLE dtb_bat_relate_products (
797    product_id number(9),
798    relate_product_id number(9),
799    customer_id number(9),
800    create_date timestamp
801);
802
803CREATE TABLE dtb_campaign (
804    campaign_id number(9) NOT NULL,
805    campaign_name varchar2(4000),
806    campaign_point_rate number(9) NOT NULL,
807    campaign_point_type number(4),
808    start_date timestamp NOT NULL,
809    end_date timestamp NOT NULL,
810    directory_name varchar2(4000) NOT NULL,
811    limit_count number(9) NOT NULL ,
812    total_count number(9) NOT NULL ,
813    orverlapping_flg number(4) NOT NULL ,
814    cart_flg number(4) NOT NULL ,
815    deliv_free_flg number(4) NOT NULL ,
816    search_condition varchar2(4000),
817    del_flg number(4) NOT NULL ,
818    create_date timestamp NOT NULL,
819    update_date timestamp NOT NULL
820);
821
822CREATE TABLE dtb_campaign_detail (
823    campaign_id number(9) NOT NULL,
824    product_id number(9) NOT NULL,
825    campaign_point_rate number(9) NOT NULL
826);
827
828CREATE TABLE dtb_pagelayout (
829    page_id number(9) NOT NULL,
830    page_name varchar2(4000),
831    url varchar2(4000) NOT NULL,
832    php_dir varchar2(4000),
833    tpl_dir varchar2(4000),
834    filename varchar2(4000),
835    header_chk number(4) ,
836    footer_chk number(4) ,
837    edit_flg number(4) ,
838    author varchar2(4000),
839    description varchar2(4000),
840    keyword varchar2(4000),
841    update_url varchar2(4000),
842    create_date timestamp NOT NULL ,
843    update_date timestamp NOT NULL
844);
845
846CREATE TABLE dtb_bloc (
847    bloc_id number(9) NOT NULL,
848    bloc_name varchar2(4000),
849    tpl_path varchar2(4000),
850    filename varchar2(4000) NOT NULL UNIQUE,
851    create_date timestamp NOT NULL ,
852    update_date timestamp NOT NULL ,
853    php_path varchar2(4000),
854    del_flg number(4) NOT NULL
855);
856
857CREATE TABLE dtb_blocposition (
858    page_id number(9) NOT NULL,
859    target_id number(9),
860    bloc_id number(9),
861    bloc_row number(9),
862    filename varchar2(4000)
863);
864
865CREATE TABLE dtb_csv (
866    no number(9),
867    csv_id number(9) NOT NULL,
868    col varchar2(4000),
869    disp_name varchar2(4000),
870    rank number(9),
871    status number(4) NOT NULL ,
872    create_date timestamp NOT NULL ,
873    update_date timestamp NOT NULL
874);
875
876CREATE TABLE dtb_csv_sql (
877    sql_id number(9),
878    sql_name varchar2(4000) NOT NULL,
879    csv_sql varchar2(4000),
880    update_date timestamp NOT NULL ,
881    create_date timestamp NOT NULL
882);
883
884CREATE TABLE dtb_user_regist (
885    user_id number(9) NOT NULL,
886    org_name varchar2(4000),
887    post_name varchar2(4000),
888    name01 varchar2(4000),
889    name02 varchar2(4000),
890    kana01 varchar2(4000),
891    kana02 varchar2(4000),
892    email varchar2(4000) NOT NULL,
893    url varchar2(4000),
894    note varchar2(4000),
895    secret_key varchar2(4000) NOT NULL UNIQUE,
896    status number(4) NOT NULL,
897    del_flg number(4) ,
898    create_date timestamp NOT NULL,
899    update_date timestamp NOT NULL
900);
901
902create table dtb_templates
903(
904template_code        varchar2(4000)        NOT NULL UNIQUE    ,
905template_name        varchar2(4000)            ,
906create_date        timestamp        NOT NULL,
907update_date        timestamp        NOT NULL
908);
909
910create table dtb_table_comment
911(
912id    number(9),
913table_name    varchar2(4000),
914column_name    varchar2(4000),
915description    varchar2(4000)
916);
917
Note: See TracBrowser for help on using the repository browser.