Project

General

Profile

« Previous | Next » 

Revision 12550

schemas/vegbien.sql: added new ~type tables

View differences:

trunk/schemas/vegbien.my.sql
1056 1056

  
1057 1057

  
1058 1058

  
1059
--
1060
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1061
--
1059 1062

  
1063
CREATE TABLE `~type._plots_01_count_of_projects` (
1064
    projects varchar(255)
1065
);
1060 1066

  
1067

  
1061 1068
--
1069
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1070
--
1071

  
1072
CREATE TABLE `~type._plots_02_list_of_project_names` (
1073
    project_name varchar(255)
1074
);
1075

  
1076

  
1077
--
1078
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1079
--
1080

  
1081
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` (
1082
    plots varchar(255)
1083
);
1084

  
1085

  
1086
--
1087
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1088
--
1089

  
1090
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` (
1091
    project_name varchar(255),
1092
    plots varchar(255)
1093
);
1094

  
1095

  
1096
--
1097
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1098
--
1099

  
1100
CREATE TABLE `~type._plots_05_list_of_plot_codes_by_project` (
1101
    project_name varchar(255),
1102
    plot_code varchar(255)
1103
);
1104

  
1105

  
1106
--
1107
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1108
--
1109

  
1110
CREATE TABLE `~type._plots_06_list_of_plots_with_stem_measurements` (
1111
    project_name varchar(255),
1112
    plot_code varchar(255)
1113
);
1114

  
1115

  
1116
--
1117
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1118
--
1119

  
1120
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` (
1121
    project_name varchar(255),
1122
    plot_code varchar(255),
1123
    individuals varchar(255)
1124
);
1125

  
1126

  
1127
--
1128
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1129
--
1130

  
1131
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` (
1132
    project_name varchar(255),
1133
    plot_code varchar(255),
1134
    stems varchar(255)
1135
);
1136

  
1137

  
1138
--
1139
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1140
--
1141

  
1142
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` (
1143
    project_name varchar(255),
1144
    plot_code varchar(255),
1145
    taxa varchar(255)
1146
);
1147

  
1148

  
1149
--
1150
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1151
--
1152

  
1153
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` (
1154
    project_name varchar(255),
1155
    plot_code varchar(255),
1156
    taxon varchar(255)
1157
);
1158

  
1159

  
1160
--
1161
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1162
--
1163

  
1164
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` (
1165
    project_name varchar(255),
1166
    plot_code varchar(255),
1167
    taxon varchar(255),
1168
    individuals varchar(255)
1169
);
1170

  
1171

  
1172
--
1173
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
1174
--
1175

  
1176
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` (
1177
    project_name varchar(255),
1178
    plot_code varchar(255),
1179
    subplots varchar(255)
1180
);
1181

  
1182

  
1183

  
1184

  
1185
--
1062 1186
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1063 1187
--
1064 1188

  
......
3870 3994

  
3871 3995

  
3872 3996
--
3873
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3874
--
3875

  
3876
CREATE TABLE `~type._plots_01_count_of_projects` (
3877
    projects varchar(255)
3878
);
3879

  
3880

  
3881
--
3882
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3883
--
3884

  
3885
CREATE TABLE `~type._plots_02_list_of_project_names` (
3886
    project_name varchar(255)
3887
);
3888

  
3889

  
3890
--
3891
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3892
--
3893

  
3894
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` (
3895
    plots varchar(255)
3896
);
3897

  
3898

  
3899
--
3900
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3901
--
3902

  
3903
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` (
3904
    project_name varchar(255),
3905
    plots varchar(255)
3906
);
3907

  
3908

  
3909
--
3910
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3911
--
3912

  
3913
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` (
3914
    project_name varchar(255),
3915
    plot_code varchar(255),
3916
    individuals varchar(255)
3917
);
3918

  
3919

  
3920
--
3921
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3922
--
3923

  
3924
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` (
3925
    project_name varchar(255),
3926
    plot_code varchar(255),
3927
    stems varchar(255)
3928
);
3929

  
3930

  
3931
--
3932
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3933
--
3934

  
3935
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` (
3936
    project_name varchar(255),
3937
    plot_code varchar(255),
3938
    taxa varchar(255)
3939
);
3940

  
3941

  
3942
--
3943
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3944
--
3945

  
3946
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` (
3947
    project_name varchar(255),
3948
    plot_code varchar(255),
3949
    taxon varchar(255)
3950
);
3951

  
3952

  
3953
--
3954
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3955
--
3956

  
3957
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` (
3958
    project_name varchar(255),
3959
    plot_code varchar(255),
3960
    taxon varchar(255),
3961
    individuals varchar(255)
3962
);
3963

  
3964

  
3965
--
3966
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3967
--
3968

  
3969
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` (
3970
    project_name varchar(255),
3971
    plot_code varchar(255),
3972
    subplots varchar(255)
3973
);
3974

  
3975

  
3976
--
3977 3997
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
3978 3998
--
3979 3999

  
......
6873 6893

  
6874 6894

  
6875 6895
--
6896
-- Data for Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE DATA; Schema: public_validations; Owner: -
6897
--
6898

  
6899

  
6900

  
6901
--
6902
-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: -
6903
--
6904

  
6905

  
6906

  
6907
--
6876 6908
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: -
6877 6909
--
6878 6910

  
trunk/schemas/vegbien.sql
2455 2455
$_$;
2456 2456

  
2457 2457

  
2458
--
2459
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2460
--
2461

  
2462
CREATE TABLE "~type._plots_01_count_of_projects" (
2463
    projects bigint
2464
);
2465

  
2466

  
2467
--
2468
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2469
--
2470

  
2471
CREATE TABLE "~type._plots_02_list_of_project_names" (
2472
    project_name text
2473
);
2474

  
2475

  
2476
--
2477
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2478
--
2479

  
2480
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" (
2481
    plots bigint
2482
);
2483

  
2484

  
2485
--
2486
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2487
--
2488

  
2489
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" (
2490
    project_name text,
2491
    plots bigint
2492
);
2493

  
2494

  
2495
--
2496
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2497
--
2498

  
2499
CREATE TABLE "~type._plots_05_list_of_plot_codes_by_project" (
2500
    project_name text,
2501
    plot_code text
2502
);
2503

  
2504

  
2505
--
2506
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2507
--
2508

  
2509
CREATE TABLE "~type._plots_06_list_of_plots_with_stem_measurements" (
2510
    project_name text,
2511
    plot_code text
2512
);
2513

  
2514

  
2515
--
2516
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2517
--
2518

  
2519
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" (
2520
    project_name text,
2521
    plot_code text,
2522
    individuals bigint
2523
);
2524

  
2525

  
2526
--
2527
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2528
--
2529

  
2530
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" (
2531
    project_name text,
2532
    plot_code text,
2533
    stems bigint
2534
);
2535

  
2536

  
2537
--
2538
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2539
--
2540

  
2541
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" (
2542
    project_name text,
2543
    plot_code text,
2544
    taxa bigint
2545
);
2546

  
2547

  
2548
--
2549
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2550
--
2551

  
2552
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" (
2553
    project_name text,
2554
    plot_code text,
2555
    taxon text
2556
);
2557

  
2558

  
2559
--
2560
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2561
--
2562

  
2563
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" (
2564
    project_name text,
2565
    plot_code text,
2566
    taxon text,
2567
    individuals bigint
2568
);
2569

  
2570

  
2571
--
2572
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
2573
--
2574

  
2575
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" (
2576
    project_name text,
2577
    plot_code text,
2578
    subplots bigint
2579
);
2580

  
2581

  
2458 2582
SET search_path = public, pg_catalog;
2459 2583

  
2460 2584
--
......
6373 6497

  
6374 6498

  
6375 6499
--
6376
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6377
--
6378

  
6379
CREATE TABLE "~type._plots_01_count_of_projects" (
6380
    projects bigint
6381
);
6382

  
6383

  
6384
--
6385
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6386
--
6387

  
6388
CREATE TABLE "~type._plots_02_list_of_project_names" (
6389
    project_name text
6390
);
6391

  
6392

  
6393
--
6394
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6395
--
6396

  
6397
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" (
6398
    plots bigint
6399
);
6400

  
6401

  
6402
--
6403
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6404
--
6405

  
6406
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" (
6407
    project_name text,
6408
    plots bigint
6409
);
6410

  
6411

  
6412
--
6413
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6414
--
6415

  
6416
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" (
6417
    project_name text,
6418
    plot_code text,
6419
    individuals bigint
6420
);
6421

  
6422

  
6423
--
6424
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6425
--
6426

  
6427
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" (
6428
    project_name text,
6429
    plot_code text,
6430
    stems bigint
6431
);
6432

  
6433

  
6434
--
6435
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6436
--
6437

  
6438
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" (
6439
    project_name text,
6440
    plot_code text,
6441
    taxa bigint
6442
);
6443

  
6444

  
6445
--
6446
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6447
--
6448

  
6449
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" (
6450
    project_name text,
6451
    plot_code text,
6452
    taxon text
6453
);
6454

  
6455

  
6456
--
6457
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6458
--
6459

  
6460
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" (
6461
    project_name text,
6462
    plot_code text,
6463
    taxon text,
6464
    individuals bigint
6465
);
6466

  
6467

  
6468
--
6469
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6470
--
6471

  
6472
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" (
6473
    project_name text,
6474
    plot_code text,
6475
    subplots bigint
6476
);
6477

  
6478

  
6479
--
6480 6500
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 
6481 6501
--
6482 6502

  
......
9376 9396

  
9377 9397

  
9378 9398
--
9399
-- Data for Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE DATA; Schema: public_validations; Owner: -
9400
--
9401

  
9402

  
9403

  
9404
--
9405
-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: -
9406
--
9407

  
9408

  
9409

  
9410
--
9379 9411
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: -
9380 9412
--
9381 9413

  

Also available in: Unified diff