1808 lines
77 KiB
Markdown
1808 lines
77 KiB
Markdown
# brapi-java 表结构关系明细（FK/PK/UK/Index）
|
||
|
||
- 来源：`src/main/resources/db/migration/V001__initial_schema.sql`
|
||
- 表数：224
|
||
- 主键约束（PK）：103
|
||
- 唯一约束（UK）：4
|
||
- 外键约束（FK）：347
|
||
- 显式索引（CREATE INDEX）：0
|
||
- CHECK 约束：0
|
||
|
||
说明：本 schema 中未发现显式 `CREATE INDEX` 语句；索引主要来自 `PRIMARY KEY` / `UNIQUE` 约束隐式创建。
|
||
|
||
## 每张表的约束与关系
|
||
|
||
### additional_info
|
||
- PK: additional_info_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): reference_bases_additional_info(additional_info_id) [fk15msc1p6ecwt2epe5hlnpjps]; genome_map_additional_info(additional_info_id) [fk1hawjjuuobdeiqip746d0n84t]; linkage_group_additional_info(additional_info_id) [fk2k54io95dt7kw0t4vla1lexty]; list_additional_info(additional_info_id) [fk4eeibramx6al3t1gswwmdr47k]; variantset_additional_info(additional_info_id) [fk4fye0aosi1a6m8hcd9lmmo5b7]; seed_lot_additional_info(additional_info_id) [fk54dkn5sk0ojmksu6lrwxlj581]; trait_additional_info(additional_info_id) [fk5sac9abi3nn6lwlt0p68yjg9b]; plate_submission_additional_info(additional_info_id) [fk5splfe3pqyuyg27n7i4vexmxa]; study_additional_info(additional_info_id) [fk72shuems686re1rmmt7fkgn02]; germplasm_attribute_value_additional_info(additional_info_id) [fk72yvh7709xknefvu6w32la2px]; callset_additional_info(additional_info_id) [fk7946n9h72ghfopq9trg4cd8jy]; reference_additional_info(additional_info_id) [fk7y0oio2jmojk6v8sbslsgodct]; program_additional_info(additional_info_id) [fk8edlew8r5esn74g77aouynrv4]; person_additional_info(additional_info_id) [fk8qn2futvwxmyyp0mh1nfia1ax]; germplasm_donor_additional_info(additional_info_id) [fk954n0e8pg58e8dy2gm52e9cpc]; pedigree_node_additional_info(additional_info_id) [fk9euom4xovmbho8f8munr3yo8u]; crossing_project_additional_info(additional_info_id) [fk9twarovit5p4n80u3p949rast]; trial_additional_info(additional_info_id) [fkacx2nuhy8i9gso9c5qv6norea]; vendor_order_additional_info(additional_info_id) [fkb0qucuwj937qoftj3hhucilkl]; observation_additional_info(additional_info_id) [fkb5f2e9tgwcnsl6khhk9dq8g9g]; cross_entity_additional_info(additional_info_id) [fkbeoyvggungwxcs0dnbe8fl8tc]; reference_set_additional_info(additional_info_id) [fkbkxd7m8yi6lkapc6xwi8k68e4]; search_additional_info(additional_info_id) [fkc607lmbugih02njrqn5won5de]; pedigree_edge_additional_info(additional_info_id) [fke0dmer2vi4gws6tobq2g48fqt]; observation_unit_additional_info(additional_info_id) [fke96np5kap7n8ewbtvduvi3xi5]; season_additional_info(additional_info_id) [fkgfda9n0n1nru5jfdau93d7rvi]; crop_additional_info(additional_info_id) [fkgsa806ghdfmb2jibt6yj0at93]; event_additional_info(additional_info_id) [fkk0b8t9ltd9pen3qtflg5fcid8]; allele_call_additional_info(additional_info_id) [fkk3eqlbxna5bu1ghw2lvd659so]; image_additional_info(additional_info_id) [fkmhmpvdrmh69ht54eh9ctoepge]; breeding_method_additional_info(additional_info_id) [fkmpeq29821uki8lu5bpshbe4yy]; scale_additional_info(additional_info_id) [fkmtoj4hkjnb1tyist5q85qr2g9]; germplasm_additional_info(additional_info_id) [fkmtyhxh8nywe41gltkodjco0qq]; method_additional_info(additional_info_id) [fko2ye8bg2c965oarcgjpbwiivq]; ontology_additional_info(additional_info_id) [fko7f8sbm28vc1kdujwm3lq7g04]; variant_additional_info(additional_info_id) [fkornm8f4smmrmdvii8bxhs8fa6]; location_additional_info(additional_info_id) [fkos7ifwhk5c6e5hs79on5dfss9]; plate_additional_info(additional_info_id) [fkp6ilw523vmukl8s757dfa996c]; variable_base_entity_additional_info(additional_info_id) [fkr7wswlsc1oglxrkx53a6gsqny]; marker_position_additional_info(additional_info_id) [fkskhha4yhni28yjy44eei6cn1m]; sample_additional_info(additional_info_id) [fkt756x10ijfwncx2h2b7arcfwk]; seed_lot_transaction_additional_info(additional_info_id) [fktoleq2k6deoeemvobenjpdir2]; vendor_spec_additional_info(additional_info_id) [fktpypusyxppcuv845ww67cxgly]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### allele
|
||
- PK: allele_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (marker_id) -> marker(id) [fk7438rbsgpvpdlc46u1akn2pwr]; (matrix_id) -> allele_matrix(id) [fk7fhkq0vxoekubgoraxv18efyt]; (marker_profile_id) -> marker_profile(id) [fk8qwjc3e6tnpyfbkmsi65vjlep]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### allele_call
|
||
- PK: allele_call_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (variant_id) -> variant(id) [fk5or2m3i1fuaq8btgm1dncqwqy]; (call_set_id) -> callset(id) [fklqve9ddl8olner2kkr6rd4003]
|
||
- 被引用(来自): allele_call_additional_info(call_entity_id) [fken1loe2e0brxlqvkdv444egfm]; allele_call_external_references(call_entity_id) [fks1ixxwy7h24uq46yj7tfuc0o4]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### allele_call_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (call_entity_id) -> allele_call(id) [fken1loe2e0brxlqvkdv444egfm]; (additional_info_id) -> additional_info(id) [fkk3eqlbxna5bu1ghw2lvd659so]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### allele_call_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk21j9fleiujdbdh1le1qxgvu76]; (call_entity_id) -> allele_call(id) [fks1ixxwy7h24uq46yj7tfuc0o4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### allele_matrix
|
||
- PK: allele_matrix_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): allele(matrix_id) [fk7fhkq0vxoekubgoraxv18efyt]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### breeding_method
|
||
- PK: breeding_method_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): breeding_method_additional_info(breeding_method_entity_id) [fkb0nay4eudi0w8g5g31v4extav]; breeding_method_external_references(breeding_method_entity_id) [fkboc2lii67kdtey1frkcsatps6]; germplasm(breeding_method_id) [fknyyqkkcjus7hj9jmhu0k6xa83]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### breeding_method_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (breeding_method_entity_id) -> breeding_method(id) [fkb0nay4eudi0w8g5g31v4extav]; (additional_info_id) -> additional_info(id) [fkmpeq29821uki8lu5bpshbe4yy]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### breeding_method_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (breeding_method_entity_id) -> breeding_method(id) [fkboc2lii67kdtey1frkcsatps6]; (external_references_id) -> external_reference(id) [fkpm6iyumy3nlcpp2ja4djklvge]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### callset
|
||
- PK: callset_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (sample_id) -> sample(id) [fkhreq22htrftm3dul7nfsg1agk]
|
||
- 被引用(来自): callset_additional_info(call_set_entity_id) [fk4d8ped8ryq98f5rxf29ooya4f]; allele_call(call_set_id) [fklqve9ddl8olner2kkr6rd4003]; callset_variant_sets(call_sets_id) [fklr5bx5nvhchf67cioqakfbu9v]; callset_external_references(call_set_entity_id) [fkq8ectsigj1r23lx3isjwrxqml]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### callset_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (call_set_entity_id) -> callset(id) [fk4d8ped8ryq98f5rxf29ooya4f]; (additional_info_id) -> additional_info(id) [fk7946n9h72ghfopq9trg4cd8jy]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### callset_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkcmhdlkwcanmd21p8gepoi0n0u]; (call_set_entity_id) -> callset(id) [fkq8ectsigj1r23lx3isjwrxqml]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### callset_variant_sets
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (call_sets_id) -> callset(id) [fklr5bx5nvhchf67cioqakfbu9v]; (variant_sets_id) -> variantset(id) [fkn62gqkvd24fje4tsoy7i64gyc]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### contact
|
||
- PK: contact_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### coordinate
|
||
- PK: coordinate_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (geojson_id) -> geojson(id) [fkdexqh6fwkb6wlewagkp7v1k98]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crop
|
||
- PK: crop_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): genome_map(crop_id) [fk2qfrqxw83mn6f9s4j6pl018s4]; location(crop_id) [fk736fp12vj9i045h2cky7v50ex]; program(crop_id) [fk820kbw8w9s0ibrsfvw3apo6d2]; observation_variable(crop_id) [fk_mns5ll4ybilsyxg20ksq514pk]; germplasm_attribute_definition(crop_id) [fk_rs20ylp9ibjagoavfko13uq9n]; crop_external_references(crop_entity_id) [fkbin2gayn9sl8khd07gf1tv0j]; trial(crop_id) [fkg0ovktlcm3w66xxj0m880rur9]; germplasm(crop_id) [fkifyh81snysy9bac2tus48jfs5]; observation(crop_id) [fkigyb0oa6sjfhgmtlspflau9hb]; crop_additional_info(crop_entity_id) [fkkmruulm21s38bld3137rutbs5]; study(crop_id) [fkmw17bwnsc3wjy5emvknrepdha]; variable_base_entity(crop_id) [fkoe75mtivumaw982qae8jqwkjl]; observation_unit(crop_id) [fkueu3tfebsye6drsenqw297bi]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crop_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkgsa806ghdfmb2jibt6yj0at93]; (crop_entity_id) -> crop(id) [fkkmruulm21s38bld3137rutbs5]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crop_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk3nlkk7gvg1523b3lbsy2q1eec]; (crop_entity_id) -> crop(id) [fkbin2gayn9sl8khd07gf1tv0j]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_entity
|
||
- PK: cross_entity_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (planned_cross_id) -> cross_entity(id) [fk4f1fo4874si5ggfcpi8ui1p8x]; (crossing_project_id) -> crossing_project(id) [fkjyf7evdes66v72l9add0i7ukj]
|
||
- 被引用(来自): cross_pollination_event(cross_id) [fk1ypb9s2niakjr3ihaphptv091]; cross_parent(cross_id) [fk31xx5db8iq2y9mtv110qxvfwg]; cross_entity(planned_cross_id) [fk4f1fo4874si5ggfcpi8ui1p8x]; cross_entity_additional_info(cross_entity_id) [fkajtg8v6usq228dwowobih89ev]; cross_entity_cross_attributes(cross_entity_id) [fkbunrh906gnkig3w246cxx037c]; observation_unit(cross_id) [fkdbndn6ma22quuinicrkjqofim]; cross_entity_external_references(cross_entity_id) [fklk5hdqw7j3kqrpxivdt9yk05o]; seed_lot_content_mixture(cross_id) [fkmg21xechkkguugmc975qwm7u0]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_entity_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (cross_entity_id) -> cross_entity(id) [fkajtg8v6usq228dwowobih89ev]; (additional_info_id) -> additional_info(id) [fkbeoyvggungwxcs0dnbe8fl8tc]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_entity_cross_attributes
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (cross_entity_id) -> cross_entity(id) [fkbunrh906gnkig3w246cxx037c]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_entity_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkjumsck59h4jv2ph2fhwfmbi2d]; (cross_entity_id) -> cross_entity(id) [fklk5hdqw7j3kqrpxivdt9yk05o]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_parent
|
||
- PK: cross_parent_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (cross_id) -> cross_entity(id) [fk31xx5db8iq2y9mtv110qxvfwg]; (germplasm_id) -> germplasm(id) [fkgwne8ni7iqgxeu5qvnjskbkvj]; (observation_unit_id) -> observation_unit(id) [fknc44kejsxwb41pqybibfkrfgd]; (crossing_project_id) -> crossing_project(id) [fkq11y3b8pxp3whpa8vihf9yr7]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### cross_pollination_event
|
||
- PK: cross_pollination_event_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (cross_id) -> cross_entity(id) [fk1ypb9s2niakjr3ihaphptv091]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crossing_project
|
||
- PK: crossing_project_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (program_id) -> program(id) [fkellju38wp5gf7191sv55r9kxe]
|
||
- 被引用(来自): pedigree_node(crossing_project_id) [fk5dmsm0lvenioadacb4gdvrv2q]; crossing_project_additional_info(crossing_project_entity_id) [fk7vigpn4dgl764ntoukgsv9uvn]; crossing_project_external_references(crossing_project_entity_id) [fk9t5w8cd5pxjih4ipygqcs6rwo]; cross_entity(crossing_project_id) [fkjyf7evdes66v72l9add0i7ukj]; cross_parent(crossing_project_id) [fkq11y3b8pxp3whpa8vihf9yr7]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crossing_project_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (crossing_project_entity_id) -> crossing_project(id) [fk7vigpn4dgl764ntoukgsv9uvn]; (additional_info_id) -> additional_info(id) [fk9twarovit5p4n80u3p949rast]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### crossing_project_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (crossing_project_entity_id) -> crossing_project(id) [fk9t5w8cd5pxjih4ipygqcs6rwo]; (external_references_id) -> external_reference(id) [fkfckwn44o1i8htq592o0s8hgac]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### data_link
|
||
- PK: data_link_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### donor
|
||
- PK: donor_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event
|
||
- PK: event_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkb21n9vqs7iyptt7vx6v6s2e07]
|
||
- 被引用(来自): event_observation_units(event_entity_id) [fk24gave7q07chv8pklo27ffjvq]; event_additional_info(event_entity_id) [fk2xgtj0io4e3cvq3t4xpoukf5v]; event_param(event_id) [fk7laguc0whfp46br0goxgkw6ry]; event_external_references(event_entity_id) [fke6ojv2849d07tagl2eslcujg9]; event_entity_dates(event_entity_id) [fkqu00khnwvqd2wgxdxa0kp7th0]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (event_entity_id) -> event(id) [fk2xgtj0io4e3cvq3t4xpoukf5v]; (additional_info_id) -> additional_info(id) [fkk0b8t9ltd9pen3qtflg5fcid8]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_entity_dates
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (event_entity_id) -> event(id) [fkqu00khnwvqd2wgxdxa0kp7th0]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (event_entity_id) -> event(id) [fke6ojv2849d07tagl2eslcujg9]; (external_references_id) -> external_reference(id) [fkig2468c6y0c60t4e0coso0ap2]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_observation_units
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (event_entity_id) -> event(id) [fk24gave7q07chv8pklo27ffjvq]; (observation_units_id) -> observation_unit(id) [fk3ecq9fb2rd3qampc61hunr7sw]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_param
|
||
- PK: event_param_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (event_id) -> event(id) [fk7laguc0whfp46br0goxgkw6ry]
|
||
- 被引用(来自): event_parameter_entity_values_by_date(event_parameter_entity_id) [fkc45rvhmlblcxqdr96qm58cg45]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### event_parameter_entity_values_by_date
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (event_parameter_entity_id) -> event_param(id) [fkc45rvhmlblcxqdr96qm58cg45]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### external_reference
|
||
- PK: external_reference_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): linkage_group_external_references(external_references_id) [fk16nwhdphvsrkfo7ldgnsiikq4]; allele_call_external_references(external_references_id) [fk21j9fleiujdbdh1le1qxgvu76]; germplasm_attribute_value_external_references(external_references_id) [fk2c187mbrv5ib1a0cpdq82i2aw]; plate_external_references(external_references_id) [fk2k8s555m1pytepl5wq7ajgyu]; image_external_references(external_references_id) [fk33bdd9xb6yxr8bnvov4shkx5a]; germplasm_donor_external_references(external_references_id) [fk3hdirn24cor15lmm3syjj9pag]; crop_external_references(external_references_id) [fk3nlkk7gvg1523b3lbsy2q1eec]; marker_position_external_references(external_references_id) [fk3pnhmjxx9bqp3rl5lo3pgos1g]; plate_submission_external_references(external_references_id) [fk4jlk3xi2ifr0b4jna9w4eu22u]; genome_map_external_references(external_references_id) [fk59wyewdtq53rnxkn55grh1nin]; location_external_references(external_references_id) [fk5bqkr4t3ly4sxsx13i76iw55f]; reference_external_references(external_references_id) [fk5nv26mmefckw1a3tilk3jvd58]; variable_base_entity_external_references(external_references_id) [fk61jsniwx483plyg24f7avmtbf]; trait_external_references(external_references_id) [fk83qwc6no22xekj3qoky28fjr]; pedigree_edge_external_references(external_references_id) [fk89dwa6f22etyvwsl2r3hc56cj]; reference_set_external_references(external_references_id) [fk9fslipqtjg4u9xj1wsx1tc1va]; ontology_external_references(external_references_id) [fkajcue8iujp37clk05ly7huxus]; search_external_references(external_references_id) [fkasoj2adq9bhxyymm4cpukjhnw]; sample_external_references(external_references_id) [fkbqjbcfol1ok5eci7kq2tyjx17]; vendor_spec_external_references(external_references_id) [fkc3usn08w7ld6ii26stfy3acwn]; seed_lot_transaction_external_references(external_references_id) [fkcmeans75yxjouc0a6t2ahsl6g]; callset_external_references(external_references_id) [fkcmhdlkwcanmd21p8gepoi0n0u]; variant_external_references(external_references_id) [fkdnw738um7f4ikcxp1iq4jsbw6]; observation_unit_external_references(external_references_id) [fkf3v8fqkjowvjos0ssmm2w8l30]; crossing_project_external_references(external_references_id) [fkfckwn44o1i8htq592o0s8hgac]; season_external_references(external_references_id) [fkfpgrbaopdh4pg1x0v785g8kl9]; germplasm_external_references(external_references_id) [fkibd3k0wfmkkjf2budoeothsub]; event_external_references(external_references_id) [fkig2468c6y0c60t4e0coso0ap2]; cross_entity_external_references(external_references_id) [fkjumsck59h4jv2ph2fhwfmbi2d]; scale_external_references(external_references_id) [fkl6qe8r2q05fnm5qdkpn694ii5]; method_external_references(external_references_id) [fkl88hj87dhueu846uo3qpqq4kt]; list_external_references(external_references_id) [fkl9fy5r4gkrlqm2woq1rh896vy]; person_external_references(external_references_id) [fklwdf8wu424ly5u7umqsn20tnc]; seed_lot_external_references(external_references_id) [fkm5uee4kohmp1o1lrv9v9ah0d4]; vendor_order_external_references(external_references_id) [fkm75b25x59xcl6u06ovhqd4ag1]; program_external_references(external_references_id) [fkn3popdlu288xgpk4wdokwqhhi]; reference_bases_external_references(external_references_id) [fkndb5wyyy87tyaa9g6k0rkxbf3]; breeding_method_external_references(external_references_id) [fkpm6iyumy3nlcpp2ja4djklvge]; trial_external_references(external_references_id) [fkq93pukjnqegcdixpqb54jdjbl]; study_external_references(external_references_id) [fkqpn1n6famc9dkaf5bjalj914d]; observation_external_references(external_references_id) [fkrfoobkjhj680bao4o0o1f96ke]; variantset_external_references(external_references_id) [fks1o96o9fb86ulu0el5om4nkmd]; pedigree_node_external_references(external_references_id) [fksoj94vfgyng2d5bhwkautd8nl]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### genome_map
|
||
- PK: genome_map_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (crop_id) -> crop(id) [fk2qfrqxw83mn6f9s4j6pl018s4]
|
||
- 被引用(来自): genome_map_additional_info(genome_map_entity_id) [fkeavq3jiy14vghritt37ydxasa]; genome_map_studies(genome_map_entity_id) [fkemp13kog5jy1924s59shmweug]; genome_map_external_references(genome_map_entity_id) [fkklkrodon3modvk940abdpec5w]; linkage_group(genome_map_id) [fkrogxv436q8e7entpcc94q7x2k]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### genome_map_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk1hawjjuuobdeiqip746d0n84t]; (genome_map_entity_id) -> genome_map(id) [fkeavq3jiy14vghritt37ydxasa]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### genome_map_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk59wyewdtq53rnxkn55grh1nin]; (genome_map_entity_id) -> genome_map(id) [fkklkrodon3modvk940abdpec5w]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### genome_map_studies
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (genome_map_entity_id) -> genome_map(id) [fkemp13kog5jy1924s59shmweug]; (studies_id) -> study(id) [fkhs0xcw9lqe8ef55rotrlcr8o9]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### geojson
|
||
- PK: geojson_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): observation(geo_coordinates_id) [fk1x98o95hroreu8udh810pyrsp]; observation_unit_position(geo_coordinates_id) [fk8nvp3yajleyeovdpi81pmrv82]; germplasm_origin(coordinates_id) [fk9i55glxpdu439oja1tx8mg8ia]; coordinate(geojson_id) [fkdexqh6fwkb6wlewagkp7v1k98]; image(coordinates_id) [fkqgoqu922hdv3ggb0amnct2muc]; location(coordinates_id) [fks18k8b2w156hg5m57b7r35fp9]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm
|
||
- PK: germplasm_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (crop_id) -> crop(id) [fkifyh81snysy9bac2tus48jfs5]; (breeding_method_id) -> breeding_method(id) [fknyyqkkcjus7hj9jmhu0k6xa83]
|
||
- 被引用(来自): germplasm_additional_info(germplasm_entity_id) [fk1i1cs1yjfqsapf370hkdowskf]; germplasm_origin(germplasm_id) [fk1m54g844qt69f241brkregk05]; germplasm_donor(germplasm_id) [fk6e02we60r9ut32qqhxb86ca72]; germplasm_search_results(germplasm_entity_id) [fk6ett5g30uvf3d4101e7ndoj8c]; seed_lot_content_mixture(germplasm_id) [fkc1gnrmj6ceuu1o4s6ffs4yjt3]; germplasm_external_references(germplasm_entity_id) [fkd0ih09ntorrw8erucyh5m6sp2]; cross_parent(germplasm_id) [fkgwne8ni7iqgxeu5qvnjskbkvj]; observation_unit(germplasm_id) [fkgykwn3x9wx8m77wy67juqlxab]; germplasm_institute(germplasm_id) [fkk9yp3d2siqb14sw6gvvrcspo6]; pedigree_node(germplasm_id) [fkkll27h6pngksanbpu2dnnldbt]; germplasm_synonym(germplasm_id) [fkkm9j9i32axrnrs34qr9q6a63n]; reference_set(source_germplasm_id) [fko1ndd24soyk8191bqhg7fegdg]; germplasm_taxon(germplasm_id) [fkokfpuhyosimp5gdloucr73vja]; germplasm_attribute_value(germplasm_id) [fkqqry5v3us53yf0o4dlcd7dxg8]; germplasm_entity_type_of_germplasm_storage_code(germplasm_entity_id) [fktahnvan5u79myt3kbqkijra78]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (germplasm_entity_id) -> germplasm(id) [fk1i1cs1yjfqsapf370hkdowskf]; (additional_info_id) -> additional_info(id) [fkmtyhxh8nywe41gltkodjco0qq]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_attribute_category
|
||
- PK: germplasm_attribute_category_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_attribute_definition
|
||
- PK: germplasm_attribute_definition_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trait_id) -> trait(id) [fk_80yoy5kaofonf13682hspj62t]; (ontology_id) -> ontology(id) [fk_am7p3efyrwwysvpxl0ccj8mni]; (method_id) -> method(id) [fk_nynfiem725rgq65kg99031j78]; (crop_id) -> crop(id) [fk_rs20ylp9ibjagoavfko13uq9n]; (scale_id) -> scale(id) [fk_smngmu0eaqhppp1d4nqb9cy8o]
|
||
- 被引用(来自): germplasm_attribute_value(attribute_id) [fk46y58bqrvcn0gymou6h0ypka8]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_attribute_value
|
||
- PK: germplasm_attribute_value_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (attribute_id) -> germplasm_attribute_definition(id) [fk46y58bqrvcn0gymou6h0ypka8]; (germplasm_id) -> germplasm(id) [fkqqry5v3us53yf0o4dlcd7dxg8]
|
||
- 被引用(来自): germplasm_attribute_value_additional_info(germplasm_attribute_value_entity_id) [fkg5fc788jirqx5dq7oyuvh1xlk]; germplasm_attribute_value_external_references(germplasm_attribute_value_entity_id) [fki9jmov5fpss3lmix8fvknrp84]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_attribute_value_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk72yvh7709xknefvu6w32la2px]; (germplasm_attribute_value_entity_id) -> germplasm_attribute_value(id) [fkg5fc788jirqx5dq7oyuvh1xlk]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_attribute_value_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk2c187mbrv5ib1a0cpdq82i2aw]; (germplasm_attribute_value_entity_id) -> germplasm_attribute_value(id) [fki9jmov5fpss3lmix8fvknrp84]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_donor
|
||
- PK: germplasm_donor_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (germplasm_id) -> germplasm(id) [fk6e02we60r9ut32qqhxb86ca72]
|
||
- 被引用(来自): germplasm_donor_additional_info(donor_entity_id) [fk3mg5891rrdo0bnnwvw4775er6]; germplasm_donor_external_references(donor_entity_id) [fk9au08uldnexgd3f00hvq2rg8k]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_donor_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (donor_entity_id) -> germplasm_donor(id) [fk3mg5891rrdo0bnnwvw4775er6]; (additional_info_id) -> additional_info(id) [fk954n0e8pg58e8dy2gm52e9cpc]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_donor_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk3hdirn24cor15lmm3syjj9pag]; (donor_entity_id) -> germplasm_donor(id) [fk9au08uldnexgd3f00hvq2rg8k]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_entity_type_of_germplasm_storage_code
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (germplasm_entity_id) -> germplasm(id) [fktahnvan5u79myt3kbqkijra78]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (germplasm_entity_id) -> germplasm(id) [fkd0ih09ntorrw8erucyh5m6sp2]; (external_references_id) -> external_reference(id) [fkibd3k0wfmkkjf2budoeothsub]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_germplasm_type_storage_code
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (germplasm_type_storage_code_dbid) -> germplasm_type_storage_code(id) [fkk16u51uagu9ruepck38qr89js]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_institute
|
||
- PK: germplasm_institute_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (germplasm_id) -> germplasm(id) [fkk9yp3d2siqb14sw6gvvrcspo6]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_origin
|
||
- PK: germplasm_origin_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (germplasm_id) -> germplasm(id) [fk1m54g844qt69f241brkregk05]; (coordinates_id) -> geojson(id) [fk9i55glxpdu439oja1tx8mg8ia]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_search_results
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (germplasm_entity_id) -> germplasm(id) [fk6ett5g30uvf3d4101e7ndoj8c]; (search_results_id) -> search(id) [fk723l9hcq17n2o9ugya6acumrp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_synonym
|
||
- PK: germplasm_synonym_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (germplasm_id) -> germplasm(id) [fkkm9j9i32axrnrs34qr9q6a63n]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_taxon
|
||
- PK: germplasm_taxon_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (germplasm_id) -> germplasm(id) [fkokfpuhyosimp5gdloucr73vja]
|
||
- 被引用(来自): sample(taxon_id_id) [fkmr8ueym2af0w8udonxhb8odix]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### germplasm_type_storage_code
|
||
- PK: germplasm_type_storage_code_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): germplasm_germplasm_type_storage_code(germplasm_type_storage_code_dbid) [fkk16u51uagu9ruepck38qr89js]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image
|
||
- PK: image_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (observation_unit_id) -> observation_unit(id) [fkob3t0l8jr07byg0p3vd06yig4]; (coordinates_id) -> geojson(id) [fkqgoqu922hdv3ggb0amnct2muc]
|
||
- 被引用(来自): image_observations(image_entity_id) [fkbwiawjcj7mihofl5puuq7k2ws]; image_entity_descriptive_ontology_terms(image_entity_id) [fkce2lade5kp0pnd7dkps05s494]; image_external_references(image_entity_id) [fkt3uy354jynflg06911dxjlu1i]; image_additional_info(image_entity_id) [fktgob5bja63ncdvs3apqpkaiel]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkmhmpvdrmh69ht54eh9ctoepge]; (image_entity_id) -> image(id) [fktgob5bja63ncdvs3apqpkaiel]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image_entity_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image_entity_descriptive_ontology_terms
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (image_entity_id) -> image(id) [fkce2lade5kp0pnd7dkps05s494]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk33bdd9xb6yxr8bnvov4shkx5a]; (image_entity_id) -> image(id) [fkt3uy354jynflg06911dxjlu1i]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### image_observations
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (image_entity_id) -> image(id) [fkbwiawjcj7mihofl5puuq7k2ws]; (observations_id) -> observation(id) [fkk8m5ehyf7axe6q7u560kvm68s]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### linkage_group
|
||
- PK: linkage_group_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (genome_map_id) -> genome_map(id) [fkrogxv436q8e7entpcc94q7x2k]
|
||
- 被引用(来自): linkage_group_external_references(linkage_group_entity_id) [fk2ngce8lv4jokyjhp72idxc4wp]; linkage_group_additional_info(linkage_group_entity_id) [fk66sqs3iw3hqvtjgtkvoysja10]; marker_position(linkage_group_id) [fki54u4vxhiuwfqt3kxev1wdkvc]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### linkage_group_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk2k54io95dt7kw0t4vla1lexty]; (linkage_group_entity_id) -> linkage_group(id) [fk66sqs3iw3hqvtjgtkvoysja10]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### linkage_group_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk16nwhdphvsrkfo7ldgnsiikq4]; (linkage_group_entity_id) -> linkage_group(id) [fk2ngce8lv4jokyjhp72idxc4wp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### list
|
||
- PK: list_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (list_owner_person_id) -> person(id) [fkimr1m8xoms2ntm15lmaruf04u]
|
||
- 被引用(来自): list_item(list_id) [fk1ddq3ct1ulogjn5ijs8ert7hw]; list_additional_info(list_entity_id) [fkke1isjiev4pwqrykkmft0iubd]; list_external_references(list_entity_id) [fkpumhc5eurjfeva73tg03qo5s4]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### list_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk4eeibramx6al3t1gswwmdr47k]; (list_entity_id) -> list(id) [fkke1isjiev4pwqrykkmft0iubd]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### list_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkl9fy5r4gkrlqm2woq1rh896vy]; (list_entity_id) -> list(id) [fkpumhc5eurjfeva73tg03qo5s4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### list_item
|
||
- PK: list_item_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (list_id) -> list(id) [fk1ddq3ct1ulogjn5ijs8ert7hw]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### location
|
||
- PK: location_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (crop_id) -> crop(id) [fk736fp12vj9i045h2cky7v50ex]; (parent_location_id) -> location(id) [fk9s1sco601u8l6ptdxf432h4kb]; (program_id) -> program(id) [fkow7as0lg8ttlh4d5chs81y46]; (coordinates_id) -> geojson(id) [fks18k8b2w156hg5m57b7r35fp9]
|
||
- 被引用(来自): location_external_references(location_entity_id) [fk74i4il2jg8ce0gi8evy3m9qto]; location(parent_location_id) [fk9s1sco601u8l6ptdxf432h4kb]; seed_lot(location_id) [fkc5lijily7i4rlqqgg6f0c11um]; location_additional_info(location_entity_id) [fkm1j1alvjyeot6agm927kka3dj]; study(location_id) [fksfltd06jhrx1cyh72tpyh2d5r]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### location_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (location_entity_id) -> location(id) [fkm1j1alvjyeot6agm927kka3dj]; (additional_info_id) -> additional_info(id) [fkos7ifwhk5c6e5hs79on5dfss9]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### location_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk5bqkr4t3ly4sxsx13i76iw55f]; (location_entity_id) -> location(id) [fk74i4il2jg8ce0gi8evy3m9qto]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker
|
||
- PK: marker_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): allele(marker_id) [fk7438rbsgpvpdlc46u1akn2pwr]; marker_marker_analysis_method(marker_db_id) [fkgarxih3kj3ujt0tpai9vvdb0o]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_analysis_method
|
||
- PK: marker_analysis_method_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): marker_marker_analysis_method(marker_analysis_method_db_id) [fkiqerxveljj6ol9xpam32lpwlh]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_marker_analysis_method
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (marker_db_id) -> marker(id) [fkgarxih3kj3ujt0tpai9vvdb0o]; (marker_analysis_method_db_id) -> marker_analysis_method(id) [fkiqerxveljj6ol9xpam32lpwlh]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_position
|
||
- PK: marker_position_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (linkage_group_id) -> linkage_group(id) [fki54u4vxhiuwfqt3kxev1wdkvc]; (variant_id) -> variant(id) [fkocqa1yc7162ddvaivrsuun0mb]
|
||
- 被引用(来自): marker_position_external_references(marker_position_entity_id) [fk4akvkw4j7xa9xc3cwa8cr60if]; marker_position_additional_info(marker_position_entity_id) [fkitpgrueaxbd8s0qgf8ejxsmbc]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_position_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (marker_position_entity_id) -> marker_position(id) [fkitpgrueaxbd8s0qgf8ejxsmbc]; (additional_info_id) -> additional_info(id) [fkskhha4yhni28yjy44eei6cn1m]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_position_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk3pnhmjxx9bqp3rl5lo3pgos1g]; (marker_position_entity_id) -> marker_position(id) [fk4akvkw4j7xa9xc3cwa8cr60if]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_profile
|
||
- PK: marker_profile_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): allele(marker_profile_id) [fk8qwjc3e6tnpyfbkmsi65vjlep]; study_marker_profile(marker_profile_db_id) [fkbynfwygpt639u6pof9whjkxfv]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_reference
|
||
- PK: marker_reference_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### marker_synonym
|
||
- PK: marker_synonym_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### method
|
||
- PK: method_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (ontology_id) -> ontology(id) [fk7i2hysyf1rsfk7bmeh50hfqrm]
|
||
- 被引用(来自): variable_base_entity(method_id) [fk57jt68g5lrxm88511ytte8wgs]; method_external_references(method_entity_id) [fk5sxdvhf5m5gvh04f4f1vubgh8]; observation_variable(method_id) [fk_30b5d7sqaviwsotg5oayomelh]; germplasm_attribute_definition(method_id) [fk_nynfiem725rgq65kg99031j78]; method_additional_info(method_entity_id) [fkncxdbq0uav0lsoetp8jdhfnf5]; method_ontology_reference(method_entity_id) [fkolyxojh3ugs13hjipaycjfkmv]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### method_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (method_entity_id) -> method(id) [fkncxdbq0uav0lsoetp8jdhfnf5]; (additional_info_id) -> additional_info(id) [fko2ye8bg2c965oarcgjpbwiivq]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### method_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (method_entity_id) -> method(id) [fk5sxdvhf5m5gvh04f4f1vubgh8]; (external_references_id) -> external_reference(id) [fkl88hj87dhueu846uo3qpqq4kt]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### method_ontology_reference
|
||
- PK: 无
|
||
- UK: uk_2o2ygrws59ot8awt3bespoboe: (ontology_reference_id)
|
||
- FK(指向): (method_entity_id) -> method(id) [fkolyxojh3ugs13hjipaycjfkmv]; (ontology_reference_id) -> ontology_ref(id) [fkt187lniiq4ulw2hbyd7jrxkii]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation
|
||
- PK: observation_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (observation_variable_id) -> observation_variable(id) [fk1hq66wld7ivshnikvlh2e3aal]; (geo_coordinates_id) -> geojson(id) [fk1x98o95hroreu8udh810pyrsp]; (trial_id) -> trial(id) [fkcviusg5q0avmk5xv7nix9gxh0]; (program_id) -> program(id) [fkf2si37d28257vfoa753hu5x1v]; (observation_unit_id) -> observation_unit(id) [fkfqw685lfh2uxxbgi60vne24jr]; (crop_id) -> crop(id) [fkigyb0oa6sjfhgmtlspflau9hb]; (season_id) -> season(id) [fkk47naotiec0cw7kpboyfbu4b1]; (study_id) -> study(id) [fkpq3oyu9tuqcttfj2dutdvgv4d]
|
||
- 被引用(来自): observation_additional_info(observation_entity_id) [fk4y4b5emdnydsykk68m9h7u5yn]; observation_external_references(observation_entity_id) [fk7bawm29wrk4oska2qqc9pv01p]; image_observations(observations_id) [fkk8m5ehyf7axe6q7u560kvm68s]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (observation_entity_id) -> observation(id) [fk4y4b5emdnydsykk68m9h7u5yn]; (additional_info_id) -> additional_info(id) [fkb5f2e9tgwcnsl6khhk9dq8g9g]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (observation_entity_id) -> observation(id) [fk7bawm29wrk4oska2qqc9pv01p]; (external_references_id) -> external_reference(id) [fkrfoobkjhj680bao4o0o1f96ke]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit
|
||
- PK: observation_unit_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trial_id) -> trial(id) [fk1bj7oq9sdtdy9sy73gj3lvxrg]; (seed_lot_id) -> seed_lot(id) [fk2u88bau3wx0bpb3f4lq0309vt]; (program_id) -> program(id) [fk5w9953xfgu6ktfwude521yhaj]; (cross_id) -> cross_entity(id) [fkdbndn6ma22quuinicrkjqofim]; (germplasm_id) -> germplasm(id) [fkgykwn3x9wx8m77wy67juqlxab]; (study_id) -> study(id) [fkra6qtii65bohk2l3hu14ocb91]; (crop_id) -> crop(id) [fkueu3tfebsye6drsenqw297bi]
|
||
- 被引用(来自): observation_unit_position(observation_unit_id) [fk2mpgvaq1ppb8kjp3jk0ecpdyr]; event_observation_units(observation_units_id) [fk3ecq9fb2rd3qampc61hunr7sw]; sample(observation_unit_id) [fk6pcuvra9s7ysh4yn2tb6wq17c]; observation_unit_level(observation_unit_id) [fk8iqhtkmddjbc4vhhf26ayx3b4]; observation_unit_treatment(observation_unit_id) [fk9aok9thr8d6dgqveur46e5985]; observation_unit_external_references(observation_unit_entity_id) [fkel9v1egnbmp20dpbkt1831ljq]; observation(observation_unit_id) [fkfqw685lfh2uxxbgi60vne24jr]; observation_unit_additional_info(observation_unit_entity_id) [fkmxg4u33203ati7ties5a20w2b]; cross_parent(observation_unit_id) [fknc44kejsxwb41pqybibfkrfgd]; image(observation_unit_id) [fkob3t0l8jr07byg0p3vd06yig4]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fke96np5kap7n8ewbtvduvi3xi5]; (observation_unit_entity_id) -> observation_unit(id) [fkmxg4u33203ati7ties5a20w2b]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (observation_unit_entity_id) -> observation_unit(id) [fkel9v1egnbmp20dpbkt1831ljq]; (external_references_id) -> external_reference(id) [fkf3v8fqkjowvjos0ssmm2w8l30]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_level
|
||
- PK: observation_unit_level_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (observation_unit_id) -> observation_unit(id) [fk8iqhtkmddjbc4vhhf26ayx3b4]; (position_id) -> observation_unit_position(id) [fkh70bs6tax01tl04ha9qjqo19]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_position
|
||
- PK: observation_unit_position_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (observation_unit_id) -> observation_unit(id) [fk2mpgvaq1ppb8kjp3jk0ecpdyr]; (geo_coordinates_id) -> geojson(id) [fk8nvp3yajleyeovdpi81pmrv82]
|
||
- 被引用(来自): observation_unit_level(position_id) [fkh70bs6tax01tl04ha9qjqo19]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_treatment
|
||
- PK: observation_unit_treatment_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (observation_unit_id) -> observation_unit(id) [fk9aok9thr8d6dgqveur46e5985]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_unit_xref
|
||
- PK: observation_unit_xref_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_variable
|
||
- PK: observation_variable_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (method_id) -> method(id) [fk_30b5d7sqaviwsotg5oayomelh]; (ontology_id) -> ontology(id) [fk_3ju23xr9v8171w7wesin5dqxw]; (trait_id) -> trait(id) [fk_f0m8ifjjlmoym2p2abs0efk6j]; (scale_id) -> scale(id) [fk_f98l70i69jgso1yousworitle]; (crop_id) -> crop(id) [fk_mns5ll4ybilsyxg20ksq514pk]
|
||
- 被引用(来自): observation(observation_variable_id) [fk1hq66wld7ivshnikvlh2e3aal]; study_variable(variable_db_id) [fkn8qb3ddd0tshid66qlgdxgssc]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_variable_context
|
||
- PK: observation_variable_context_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### observation_variable_synonym
|
||
- PK: observation_variable_synonym_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### ontology
|
||
- PK: ontology_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): variable_base_entity(ontology_id) [fk3qk7upe0cpk9r8vkjwn82bigc]; ontology_additional_info(ontology_entity_id) [fk5vn4w4w53dh5jbvp3jg35tpy2]; ontology_external_references(ontology_entity_id) [fk60ha4xhme1qcj9qlef16x5uf4]; method(ontology_id) [fk7i2hysyf1rsfk7bmeh50hfqrm]; observation_variable(ontology_id) [fk_3ju23xr9v8171w7wesin5dqxw]; germplasm_attribute_definition(ontology_id) [fk_am7p3efyrwwysvpxl0ccj8mni]; scale(ontology_id) [fkfuvpau9fbqw8ukt0hpr1coxxb]; trait(ontology_id) [fkfy6vs593as3gs6tadmey5s2ad]; ontology_entity_documentation_links(ontology_entity_id) [fkm0elv2jxmknlgb0ov2q7cv5e7]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### ontology_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (ontology_entity_id) -> ontology(id) [fk5vn4w4w53dh5jbvp3jg35tpy2]; (additional_info_id) -> additional_info(id) [fko7f8sbm28vc1kdujwm3lq7g04]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### ontology_entity_documentation_links
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (ontology_entity_id) -> ontology(id) [fkm0elv2jxmknlgb0ov2q7cv5e7]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### ontology_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (ontology_entity_id) -> ontology(id) [fk60ha4xhme1qcj9qlef16x5uf4]; (external_references_id) -> external_reference(id) [fkajcue8iujp37clk05ly7huxus]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### ontology_ref
|
||
- PK: ontology_ref_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): scale_ontology_reference(ontology_reference_id) [fk1baxxkxrgpqqd5inp7rdl2ww6]; variable_base_entity_ontology_reference(ontology_reference_id) [fk4kfhpym5gotqg7ebh9rxs7pli]; trait_ontology_reference(ontology_reference_id) [fki80mf7yhx7xoh3nt4tb0ptxg0]; method_ontology_reference(ontology_reference_id) [fkt187lniiq4ulw2hbyd7jrxkii]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree
|
||
- PK: pedigree_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (parent2_db_id) -> pedigree(id) [fkm3fw6jl9fdir0lu8dgop2glgb]; (parent1_db_id) -> pedigree(id) [fkr4crrn7ql4t6drjo91qew7mhr]
|
||
- 被引用(来自): pedigree(parent2_db_id) [fkm3fw6jl9fdir0lu8dgop2glgb]; pedigree(parent1_db_id) [fkr4crrn7ql4t6drjo91qew7mhr]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_edge
|
||
- PK: pedigree_edge_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (connceted_node_id) -> pedigree_node(id) [fk5ds4uo4f3tsurnjtc8dxb7w6r]; (this_node_id) -> pedigree_node(id) [fk89pdbyb8xx3eua9b9i5cu5ltq]
|
||
- 被引用(来自): pedigree_edge_additional_info(pedigree_edge_entity_id) [fk7oyompkxdf9qfdw5vhi7jwob7]; pedigree_edge_external_references(pedigree_edge_entity_id) [fk8b66j4ff2axcsuosr5erotn8e]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_edge_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (pedigree_edge_entity_id) -> pedigree_edge(id) [fk7oyompkxdf9qfdw5vhi7jwob7]; (additional_info_id) -> additional_info(id) [fke0dmer2vi4gws6tobq2g48fqt]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_edge_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk89dwa6f22etyvwsl2r3hc56cj]; (pedigree_edge_entity_id) -> pedigree_edge(id) [fk8b66j4ff2axcsuosr5erotn8e]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_node
|
||
- PK: pedigree_node_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (crossing_project_id) -> crossing_project(id) [fk5dmsm0lvenioadacb4gdvrv2q]; (germplasm_id) -> germplasm(id) [fkkll27h6pngksanbpu2dnnldbt]
|
||
- 被引用(来自): pedigree_node_additional_info(pedigree_node_entity_id) [fk1t5n6ki879po879s67awvsm8y]; pedigree_edge(connceted_node_id) [fk5ds4uo4f3tsurnjtc8dxb7w6r]; pedigree_edge(this_node_id) [fk89pdbyb8xx3eua9b9i5cu5ltq]; pedigree_node_external_references(pedigree_node_entity_id) [fkfg0jmv1958u8qmsd796xft78w]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_node_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (pedigree_node_entity_id) -> pedigree_node(id) [fk1t5n6ki879po879s67awvsm8y]; (additional_info_id) -> additional_info(id) [fk9euom4xovmbho8f8munr3yo8u]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### pedigree_node_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (pedigree_node_entity_id) -> pedigree_node(id) [fkfg0jmv1958u8qmsd796xft78w]; (external_references_id) -> external_reference(id) [fksoj94vfgyng2d5bhwkautd8nl]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### person
|
||
- PK: person_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): trial_contact(person_db_id) [fkbpd4t24op9qhsh3vnljww0eo8]; program(lead_person_id) [fkfi6d6cc591slcqibawxp0m1pd]; person_external_references(person_entity_id) [fkfxl2xseolst0sb8pci7o7yxy]; list(list_owner_person_id) [fkimr1m8xoms2ntm15lmaruf04u]; study_contact(person_db_id) [fklcxxwlmhrlueccix1jwq3i4ul]; person_additional_info(person_entity_id) [fkpxbki7aent2sujme4k2hkxipq]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### person_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk8qn2futvwxmyyp0mh1nfia1ax]; (person_entity_id) -> person(id) [fkpxbki7aent2sujme4k2hkxipq]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### person_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (person_entity_id) -> person(id) [fkfxl2xseolst0sb8pci7o7yxy]; (external_references_id) -> external_reference(id) [fklwdf8wu424ly5u7umqsn20tnc]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate
|
||
- PK: plate_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (submission_id) -> plate_submission(id) [fkgt7xe0jip2aekvx0nei3t3s67]; (study_id) -> study(id) [fkihx8xx6p59h4rkgsd2qa5vyia]; (trial_id) -> trial(id) [fkky4n35tyqgvf2hwq6958yo765]; (program_id) -> program(id) [fkquqjxsw3cp462nlrpcb9dp6d7]
|
||
- 被引用(来自): plate_external_references(plate_entity_id) [fk7waq4smg9jdsn9v87ovfn0irl]; plate_additional_info(plate_entity_id) [fkgb681lp8w3b31kwwi25wrdjpw]; sample(plate_id) [fkgxtnyp78l7na5g0li648fy82u]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (plate_entity_id) -> plate(id) [fkgb681lp8w3b31kwwi25wrdjpw]; (additional_info_id) -> additional_info(id) [fkp6ilw523vmukl8s757dfa996c]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk2k8s555m1pytepl5wq7ajgyu]; (plate_entity_id) -> plate(id) [fk7waq4smg9jdsn9v87ovfn0irl]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate_submission
|
||
- PK: plate_submission_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (order_id) -> vendor_order(id) [fkp6b3ib0xl55upbyhk3fm15r1q]
|
||
- 被引用(来自): plate_submission_external_references(vendor_plate_submission_entity_id) [fk4qkh6qsuqtjrp8hj73kn6h0su]; plate_submission_additional_info(vendor_plate_submission_entity_id) [fkdpithbfhkpwgeh1w4owmbbvao]; plate(submission_id) [fkgt7xe0jip2aekvx0nei3t3s67]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate_submission_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk5splfe3pqyuyg27n7i4vexmxa]; (vendor_plate_submission_entity_id) -> plate_submission(id) [fkdpithbfhkpwgeh1w4owmbbvao]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### plate_submission_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk4jlk3xi2ifr0b4jna9w4eu22u]; (vendor_plate_submission_entity_id) -> plate_submission(id) [fk4qkh6qsuqtjrp8hj73kn6h0su]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### program
|
||
- PK: program_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (crop_id) -> crop(id) [fk820kbw8w9s0ibrsfvw3apo6d2]; (lead_person_id) -> person(id) [fkfi6d6cc591slcqibawxp0m1pd]
|
||
- 被引用(来自): sample(program_id) [fk1bqip06xsj05fdvhodjwta4i2]; trial(program_id) [fk3qx9s6f3fgimmnmcw95djunib]; program_additional_info(program_entity_id) [fk4g2ai4vsbheaqta3lgxtlnslh]; observation_unit(program_id) [fk5w9953xfgu6ktfwude521yhaj]; program_external_references(program_entity_id) [fk9k5htwyl0rrhadlr2bvtb4ewh]; study(program_id) [fkcgg6j1kp9h2noravxy8v0yfc0]; crossing_project(program_id) [fkellju38wp5gf7191sv55r9kxe]; observation(program_id) [fkf2si37d28257vfoa753hu5x1v]; seed_lot(program_id) [fkhwgjxt97ds2usyh8wmk4ec4qu]; location(program_id) [fkow7as0lg8ttlh4d5chs81y46]; plate(program_id) [fkquqjxsw3cp462nlrpcb9dp6d7]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### program_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (program_entity_id) -> program(id) [fk4g2ai4vsbheaqta3lgxtlnslh]; (additional_info_id) -> additional_info(id) [fk8edlew8r5esn74g77aouynrv4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### program_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (program_entity_id) -> program(id) [fk9k5htwyl0rrhadlr2bvtb4ewh]; (external_references_id) -> external_reference(id) [fkn3popdlu288xgpk4wdokwqhhi]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference
|
||
- PK: reference_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (reference_set_id) -> reference_set(id) [fkpr6hqcaxgwgl0uom9wo22om65]
|
||
- 被引用(来自): reference_additional_info(reference_entity_id) [fk5yu6dt6n29x5le3bsncfgtih2]; reference_external_references(reference_entity_id) [fkr0nxjwbpehkbp8vfg3xyql5vy]; reference_bases(reference_id) [fkro4r722mjgl8huj88soea80le]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (reference_entity_id) -> reference(id) [fk5yu6dt6n29x5le3bsncfgtih2]; (additional_info_id) -> additional_info(id) [fk7y0oio2jmojk6v8sbslsgodct]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_bases
|
||
- PK: reference_bases_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (reference_id) -> reference(id) [fkro4r722mjgl8huj88soea80le]
|
||
- 被引用(来自): reference_bases_additional_info(reference_bases_page_entity_id) [fk86atf2yqcpk85idvuina9l1ro]; reference_bases_external_references(reference_bases_page_entity_id) [fkf6sny2j9k3hugyrp6iut22oo]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_bases_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk15msc1p6ecwt2epe5hlnpjps]; (reference_bases_page_entity_id) -> reference_bases(id) [fk86atf2yqcpk85idvuina9l1ro]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_bases_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (reference_bases_page_entity_id) -> reference_bases(id) [fkf6sny2j9k3hugyrp6iut22oo]; (external_references_id) -> external_reference(id) [fkndb5wyyy87tyaa9g6k0rkxbf3]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk5nv26mmefckw1a3tilk3jvd58]; (reference_entity_id) -> reference(id) [fkr0nxjwbpehkbp8vfg3xyql5vy]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_set
|
||
- PK: reference_set_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (source_germplasm_id) -> germplasm(id) [fko1ndd24soyk8191bqhg7fegdg]
|
||
- 被引用(来自): reference_set_external_references(reference_set_entity_id) [fkbk2b1k68f0drytr6pkncudxoh]; variant(reference_set_id) [fkh523hkn6t8iurf19bb19o7px7]; reference_set_additional_info(reference_set_entity_id) [fkmc0tpp535gohxpoiroeyqlr4e]; variantset(reference_set_id) [fkoy17h5s7f83vl8rfcpeqduhp3]; reference(reference_set_id) [fkpr6hqcaxgwgl0uom9wo22om65]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_set_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkbkxd7m8yi6lkapc6xwi8k68e4]; (reference_set_entity_id) -> reference_set(id) [fkmc0tpp535gohxpoiroeyqlr4e]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### reference_set_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk9fslipqtjg4u9xj1wsx1tc1va]; (reference_set_entity_id) -> reference_set(id) [fkbk2b1k68f0drytr6pkncudxoh]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### sample
|
||
- PK: sample_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (program_id) -> program(id) [fk1bqip06xsj05fdvhodjwta4i2]; (observation_unit_id) -> observation_unit(id) [fk6pcuvra9s7ysh4yn2tb6wq17c]; (trial_id) -> trial(id) [fk8p8p683y5axjauvbt4bgp0lly]; (plate_id) -> plate(id) [fkgxtnyp78l7na5g0li648fy82u]; (study_id) -> study(id) [fkkbdme00c5ep0xx088cjvgh4i7]; (taxon_id_id) -> germplasm_taxon(id) [fkmr8ueym2af0w8udonxhb8odix]
|
||
- 被引用(来自): sample_additional_info(sample_entity_id) [fk5jvdgvkhrsxdhp87673niumtp]; sample_external_references(sample_entity_id) [fkdjnhuxmo83frqm5o5bbkbnyxq]; vendor_file_sample(sample_dbid) [fke3tnyn895kve2kgixku4j7htb]; callset(sample_id) [fkhreq22htrftm3dul7nfsg1agk]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### sample_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (sample_entity_id) -> sample(id) [fk5jvdgvkhrsxdhp87673niumtp]; (additional_info_id) -> additional_info(id) [fkt756x10ijfwncx2h2b7arcfwk]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### sample_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkbqjbcfol1ok5eci7kq2tyjx17]; (sample_entity_id) -> sample(id) [fkdjnhuxmo83frqm5o5bbkbnyxq]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale
|
||
- PK: scale_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (ontology_id) -> ontology(id) [fkfuvpau9fbqw8ukt0hpr1coxxb]
|
||
- 被引用(来自): scale_ontology_reference(scale_entity_id) [fk23l4o7tx5iov7l8x61ektcvig]; scale_additional_info(scale_entity_id) [fk7gl7xa8xao4g810motmx4gy5m]; observation_variable(scale_id) [fk_f98l70i69jgso1yousworitle]; germplasm_attribute_definition(scale_id) [fk_smngmu0eaqhppp1d4nqb9cy8o]; scale_valid_value_category(scale_id) [fkjhq7himmbn2jaku9qvpfq3vkd]; scale_external_references(scale_entity_id) [fkp6jdfm8j68sdcffih55dq6ypb]; variable_base_entity(scale_id) [fkt231xoex97i7luntla7du6guv]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (scale_entity_id) -> scale(id) [fk7gl7xa8xao4g810motmx4gy5m]; (additional_info_id) -> additional_info(id) [fkmtoj4hkjnb1tyist5q85qr2g9]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale_entity_valid_value_categories
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkl6qe8r2q05fnm5qdkpn694ii5]; (scale_entity_id) -> scale(id) [fkp6jdfm8j68sdcffih55dq6ypb]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale_ontology_reference
|
||
- PK: 无
|
||
- UK: uk_ac9pepdho097g1h1uvpqspcdk: (ontology_reference_id)
|
||
- FK(指向): (ontology_reference_id) -> ontology_ref(id) [fk1baxxkxrgpqqd5inp7rdl2ww6]; (scale_entity_id) -> scale(id) [fk23l4o7tx5iov7l8x61ektcvig]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### scale_valid_value_category
|
||
- PK: scale_valid_value_category_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (scale_id) -> scale(id) [fkjhq7himmbn2jaku9qvpfq3vkd]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### search
|
||
- PK: search_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): germplasm_search_results(search_results_id) [fk723l9hcq17n2o9ugya6acumrp]; search_additional_info(search_request_entity_id) [fkhwvys4ofud3pffy75khmerbxy]; search_external_references(search_request_entity_id) [fkkkrkct3cg8r8tdjpdagavq98l]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### search_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkc607lmbugih02njrqn5won5de]; (search_request_entity_id) -> search(id) [fkhwvys4ofud3pffy75khmerbxy]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### search_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkasoj2adq9bhxyymm4cpukjhnw]; (search_request_entity_id) -> search(id) [fkkkrkct3cg8r8tdjpdagavq98l]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### season
|
||
- PK: season_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): study_season(season_db_id) [fki5yn2nqtqrw3mh1qoeyxxmyvp]; observation(season_id) [fkk47naotiec0cw7kpboyfbu4b1]; season_additional_info(season_entity_id) [fko2ck6c1svnhopldbgb3w4f8mr]; season_external_references(season_entity_id) [fktd03hbghqblpq7ril3on0tbvk]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### season_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkgfda9n0n1nru5jfdau93d7rvi]; (season_entity_id) -> season(id) [fko2ck6c1svnhopldbgb3w4f8mr]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### season_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkfpgrbaopdh4pg1x0v785g8kl9]; (season_entity_id) -> season(id) [fktd03hbghqblpq7ril3on0tbvk]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot
|
||
- PK: seed_lot_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (location_id) -> location(id) [fkc5lijily7i4rlqqgg6f0c11um]; (program_id) -> program(id) [fkhwgjxt97ds2usyh8wmk4ec4qu]
|
||
- 被引用(来自): seed_lot_content_mixture(seed_lot_id) [fk27vg35ttok90l5a06j0pkcacm]; observation_unit(seed_lot_id) [fk2u88bau3wx0bpb3f4lq0309vt]; seed_lot_transaction(from_seed_lot_id) [fk93w5dw8nj2fxxsow0ck0ila4w]; seed_lot_external_references(seed_lot_entity_id) [fkcbgmrnalhithf1ba1usguxia3]; seed_lot_additional_info(seed_lot_entity_id) [fkkc24okl66lvimenfnd9m5ofrp]; seed_lot_transaction(to_seed_lot_id) [fkqbk3jxmv73a38qv214gf2awq7]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk54dkn5sk0ojmksu6lrwxlj581]; (seed_lot_entity_id) -> seed_lot(id) [fkkc24okl66lvimenfnd9m5ofrp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_content_mixture
|
||
- PK: seed_lot_content_mixture_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (seed_lot_id) -> seed_lot(id) [fk27vg35ttok90l5a06j0pkcacm]; (germplasm_id) -> germplasm(id) [fkc1gnrmj6ceuu1o4s6ffs4yjt3]; (cross_id) -> cross_entity(id) [fkmg21xechkkguugmc975qwm7u0]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (seed_lot_entity_id) -> seed_lot(id) [fkcbgmrnalhithf1ba1usguxia3]; (external_references_id) -> external_reference(id) [fkm5uee4kohmp1o1lrv9v9ah0d4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_transaction
|
||
- PK: seed_lot_transaction_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (from_seed_lot_id) -> seed_lot(id) [fk93w5dw8nj2fxxsow0ck0ila4w]; (to_seed_lot_id) -> seed_lot(id) [fkqbk3jxmv73a38qv214gf2awq7]
|
||
- 被引用(来自): seed_lot_transaction_additional_info(seed_lot_transaction_entity_id) [fk4e883texgqul3lmwtu2gujwpx]; seed_lot_transaction_external_references(seed_lot_transaction_entity_id) [fkjsg1potilwjdyt0uk3jmx5nv0]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_transaction_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (seed_lot_transaction_entity_id) -> seed_lot_transaction(id) [fk4e883texgqul3lmwtu2gujwpx]; (additional_info_id) -> additional_info(id) [fktoleq2k6deoeemvobenjpdir2]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### seed_lot_transaction_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkcmeans75yxjouc0a6t2ahsl6g]; (seed_lot_transaction_entity_id) -> seed_lot_transaction(id) [fkjsg1potilwjdyt0uk3jmx5nv0]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study
|
||
- PK: study_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trial_id) -> trial(id) [fk9voefp8el048ula850imkkuiq]; (program_id) -> program(id) [fkcgg6j1kp9h2noravxy8v0yfc0]; (crop_id) -> crop(id) [fkmw17bwnsc3wjy5emvknrepdha]; (location_id) -> location(id) [fksfltd06jhrx1cyh72tpyh2d5r]
|
||
- 被引用(来自): study_season(study_db_id) [fk1r2518mglhwijy5mk31cfxh3h]; study_experimental_design(study_id) [fk6p1eig0ibi880tu9yr3vd8yfn]; event(study_id) [fkb21n9vqs7iyptt7vx6v6s2e07]; study_variable(study_db_id) [fkdg1qfle74hjs7s6a31j6poxs]; study_additional_info(study_entity_id) [fkg741lptjnoyu2sg5dngulq9gn]; study_growth_facility(study_id) [fkhie58olkxqm2t1ht6k5hl4wu5]; study_environment_parameter(study_id) [fkhkcbdh997uw56v7orukh2hssm]; genome_map_studies(studies_id) [fkhs0xcw9lqe8ef55rotrlcr8o9]; plate(study_id) [fkihx8xx6p59h4rkgsd2qa5vyia]; sample(study_id) [fkkbdme00c5ep0xx088cjvgh4i7]; variantset(study_id) [fkmycnt85wyf9x7q45h9wjy0ehj]; study_data_link(study_id) [fknhgb2dwb4ffbsmydrhmephyyd]; study_last_update(study_id) [fkogmwhwbr1qx6vr1qr1nh6owpp]; study_contact(study_db_id) [fkojmdovj11j3s8qxewlfjuw08y]; observation(study_id) [fkpq3oyu9tuqcttfj2dutdvgv4d]; study_observation_level(study_id) [fkq886b0f9213w91opmlha96b0g]; observation_unit(study_id) [fkra6qtii65bohk2l3hu14ocb91]; study_external_references(study_entity_id) [fksj8raswfnpyuh1fwf8yfu53qk]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk72shuems686re1rmmt7fkgn02]; (study_entity_id) -> study(id) [fkg741lptjnoyu2sg5dngulq9gn]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_contact
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (person_db_id) -> person(id) [fklcxxwlmhrlueccix1jwq3i4ul]; (study_db_id) -> study(id) [fkojmdovj11j3s8qxewlfjuw08y]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_data_link
|
||
- PK: study_data_link_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fknhgb2dwb4ffbsmydrhmephyyd]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_environment_parameter
|
||
- PK: study_environment_parameter_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkhkcbdh997uw56v7orukh2hssm]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_experimental_design
|
||
- PK: study_experimental_design_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fk6p1eig0ibi880tu9yr3vd8yfn]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkqpn1n6famc9dkaf5bjalj914d]; (study_entity_id) -> study(id) [fksj8raswfnpyuh1fwf8yfu53qk]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_growth_facility
|
||
- PK: study_growth_facility_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkhie58olkxqm2t1ht6k5hl4wu5]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_last_update
|
||
- PK: study_last_update_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkogmwhwbr1qx6vr1qr1nh6owpp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_marker_profile
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (marker_profile_db_id) -> marker_profile(id) [fkbynfwygpt639u6pof9whjkxfv]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_observation_level
|
||
- PK: study_observation_level_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkq886b0f9213w91opmlha96b0g]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_season
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (study_db_id) -> study(id) [fk1r2518mglhwijy5mk31cfxh3h]; (season_db_id) -> season(id) [fki5yn2nqtqrw3mh1qoeyxxmyvp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_type
|
||
- PK: study_type_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### study_variable
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (study_db_id) -> study(id) [fkdg1qfle74hjs7s6a31j6poxs]; (variable_db_id) -> observation_variable(id) [fkn8qb3ddd0tshid66qlgdxgssc]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### taxon
|
||
- PK: taxon_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait
|
||
- PK: trait_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (ontology_id) -> ontology(id) [fkfy6vs593as3gs6tadmey5s2ad]
|
||
- 被引用(来自): trait_external_references(trait_entity_id) [fk26xyvg9wub4k3iv7519mi4fm6]; germplasm_attribute_definition(trait_id) [fk_80yoy5kaofonf13682hspj62t]; observation_variable(trait_id) [fk_f0m8ifjjlmoym2p2abs0efk6j]; variable_base_entity(trait_id) [fka5x8r7mfq04ttwj9ssls0uft4]; trait_additional_info(trait_entity_id) [fkfdo433yeiqekt02djxvwqjqna]; trait_entity_alternative_abbreviations(trait_entity_id) [fkhattlnir8onuakl31y2yjxs4n]; trait_entity_synonyms(trait_entity_id) [fkla1w2g0gglyqr1gk7s4v59y7m]; trait_abbreviation(trait_id) [fkrar3erhikad78x1vsh6uvp2aw]; trait_synonym(trait_id) [fkrdvotrungvhk06df1kx4bo7mb]; trait_ontology_reference(trait_entity_id) [fksxd4d5p4m8xhvsguxfxonqck]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_abbreviation
|
||
- PK: trait_abbreviation_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trait_id) -> trait(id) [fkrar3erhikad78x1vsh6uvp2aw]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk5sac9abi3nn6lwlt0p68yjg9b]; (trait_entity_id) -> trait(id) [fkfdo433yeiqekt02djxvwqjqna]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_entity_alternative_abbreviations
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (trait_entity_id) -> trait(id) [fkhattlnir8onuakl31y2yjxs4n]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_entity_synonyms
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (trait_entity_id) -> trait(id) [fkla1w2g0gglyqr1gk7s4v59y7m]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (trait_entity_id) -> trait(id) [fk26xyvg9wub4k3iv7519mi4fm6]; (external_references_id) -> external_reference(id) [fk83qwc6no22xekj3qoky28fjr]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_ontology_reference
|
||
- PK: 无
|
||
- UK: uk_6dpui3np8x0r3x6lku3jyuyts: (ontology_reference_id)
|
||
- FK(指向): (ontology_reference_id) -> ontology_ref(id) [fki80mf7yhx7xoh3nt4tb0ptxg0]; (trait_entity_id) -> trait(id) [fksxd4d5p4m8xhvsguxfxonqck]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trait_synonym
|
||
- PK: trait_synonym_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trait_id) -> trait(id) [fkrdvotrungvhk06df1kx4bo7mb]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### treatment
|
||
- PK: treatment_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial
|
||
- PK: trial_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (program_id) -> program(id) [fk3qx9s6f3fgimmnmcw95djunib]; (crop_id) -> crop(id) [fkg0ovktlcm3w66xxj0m880rur9]
|
||
- 被引用(来自): trial_external_references(trial_entity_id) [fk155y3dfx5kbikdaea1ev83f2q]; observation_unit(trial_id) [fk1bj7oq9sdtdy9sy73gj3lvxrg]; trial_additional_info(trial_entity_id) [fk2eb8mjd3rilh4qrwgivoocg70]; trial_publication(trial_id) [fk3mtl83xv18xwseiuvrog2crft]; sample(trial_id) [fk8p8p683y5axjauvbt4bgp0lly]; study(trial_id) [fk9voefp8el048ula850imkkuiq]; observation(trial_id) [fkcviusg5q0avmk5xv7nix9gxh0]; trial_dataset_authorship(trial_id) [fkd13q53ipjrr22rkelycgxjio4]; trial_contact(trial_db_id) [fkeqh9256ey5a136uatx4hu6gc4]; plate(trial_id) [fkky4n35tyqgvf2hwq6958yo765]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (trial_entity_id) -> trial(id) [fk2eb8mjd3rilh4qrwgivoocg70]; (additional_info_id) -> additional_info(id) [fkacx2nuhy8i9gso9c5qv6norea]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial_contact
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (person_db_id) -> person(id) [fkbpd4t24op9qhsh3vnljww0eo8]; (trial_db_id) -> trial(id) [fkeqh9256ey5a136uatx4hu6gc4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial_dataset_authorship
|
||
- PK: trial_dataset_authorship_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trial_id) -> trial(id) [fkd13q53ipjrr22rkelycgxjio4]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (trial_entity_id) -> trial(id) [fk155y3dfx5kbikdaea1ev83f2q]; (external_references_id) -> external_reference(id) [fkq93pukjnqegcdixpqb54jdjbl]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### trial_publication
|
||
- PK: trial_publication_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (trial_id) -> trial(id) [fk3mtl83xv18xwseiuvrog2crft]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity
|
||
- PK: variable_base_entity_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (ontology_id) -> ontology(id) [fk3qk7upe0cpk9r8vkjwn82bigc]; (method_id) -> method(id) [fk57jt68g5lrxm88511ytte8wgs]; (trait_id) -> trait(id) [fka5x8r7mfq04ttwj9ssls0uft4]; (crop_id) -> crop(id) [fkoe75mtivumaw982qae8jqwkjl]; (scale_id) -> scale(id) [fkt231xoex97i7luntla7du6guv]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkr7wswlsc1oglxrkx53a6gsqny]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity_context_of_use
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fk61jsniwx483plyg24f7avmtbf]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity_ontology_reference
|
||
- PK: 无
|
||
- UK: uk_b01mhfwes5mno4yqnews4dxht: (ontology_reference_id)
|
||
- FK(指向): (ontology_reference_id) -> ontology_ref(id) [fk4kfhpym5gotqg7ebh9rxs7pli]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variable_base_entity_synonyms
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant
|
||
- PK: variant_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (reference_set_id) -> reference_set(id) [fkh523hkn6t8iurf19bb19o7px7]; (variant_set_id) -> variantset(id) [fkhxdkan6bx84xlww89gy9wr9q8]
|
||
- 被引用(来自): allele_call(variant_id) [fk5or2m3i1fuaq8btgm1dncqwqy]; variant_entity_ciend(variant_entity_id) [fk9dsm85o8qltahmd03symbgohp]; variant_external_references(variant_entity_id) [fkgoibfri9bvwfh4jd8snqwcw5u]; variant_entity_cipos(variant_entity_id) [fkh94uec6mbay6eld1uxk1m2xbi]; variant_entity_filters_failed(variant_entity_id) [fki10kljn84l12s881v3bxdh34n]; variant_additional_info(variant_entity_id) [fknkg21jfw2m15nrt5wsg0j05kn]; marker_position(variant_id) [fkocqa1yc7162ddvaivrsuun0mb]; variant_entity_alternate_bases(variant_entity_id) [fkv6ptn907aedytbh5w8mc6t3r]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_entity_id) -> variant(id) [fknkg21jfw2m15nrt5wsg0j05kn]; (additional_info_id) -> additional_info(id) [fkornm8f4smmrmdvii8bxhs8fa6]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_entity_alternate_bases
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_entity_id) -> variant(id) [fkv6ptn907aedytbh5w8mc6t3r]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_entity_ciend
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_entity_id) -> variant(id) [fk9dsm85o8qltahmd03symbgohp]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_entity_cipos
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_entity_id) -> variant(id) [fkh94uec6mbay6eld1uxk1m2xbi]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_entity_filters_failed
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_entity_id) -> variant(id) [fki10kljn84l12s881v3bxdh34n]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkdnw738um7f4ikcxp1iq4jsbw6]; (variant_entity_id) -> variant(id) [fkgoibfri9bvwfh4jd8snqwcw5u]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variant_set_analysis_entity_software
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_set_analysis_entity_id) -> variantset_analysis(id) [fknx3gnntbonjgjc55csk4bqejb]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variantset
|
||
- PK: variantset_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (study_id) -> study(id) [fkmycnt85wyf9x7q45h9wjy0ehj]; (reference_set_id) -> reference_set(id) [fkoy17h5s7f83vl8rfcpeqduhp3]
|
||
- 被引用(来自): variantset_additional_info(variant_set_entity_id) [fk8qu019buvb5xnd6fotaswf30q]; variantset_external_references(variant_set_entity_id) [fkckhrweboc7ktl0e7obei7731f]; variant(variant_set_id) [fkhxdkan6bx84xlww89gy9wr9q8]; callset_variant_sets(variant_sets_id) [fkn62gqkvd24fje4tsoy7i64gyc]; variantset_analysis(variant_set_id) [fko9jtegpt029eaca8mifd8yrm4]; variantset_format(variant_set_id) [fkse2qx2lkfhnb00nnoexcpa1fu]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variantset_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fk4fye0aosi1a6m8hcd9lmmo5b7]; (variant_set_entity_id) -> variantset(id) [fk8qu019buvb5xnd6fotaswf30q]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variantset_analysis
|
||
- PK: variantset_analysis_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (variant_set_id) -> variantset(id) [fko9jtegpt029eaca8mifd8yrm4]
|
||
- 被引用(来自): variant_set_analysis_entity_software(variant_set_analysis_entity_id) [fknx3gnntbonjgjc55csk4bqejb]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variantset_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (variant_set_entity_id) -> variantset(id) [fkckhrweboc7ktl0e7obei7731f]; (external_references_id) -> external_reference(id) [fks1o96o9fb86ulu0el5om4nkmd]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### variantset_format
|
||
- PK: variantset_format_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (variant_set_id) -> variantset(id) [fkse2qx2lkfhnb00nnoexcpa1fu]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_file
|
||
- PK: vendor_file_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (order_id) -> vendor_order(id) [fk2sn16vflr7mjc9riwq7ee7fxk]
|
||
- 被引用(来自): vendor_file_sample(verndor_file_dbid) [fkhb1jmpjfglf5idqj5rrkqvkg1]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_file_sample
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (sample_dbid) -> sample(id) [fke3tnyn895kve2kgixku4j7htb]; (verndor_file_dbid) -> vendor_file(id) [fkhb1jmpjfglf5idqj5rrkqvkg1]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_order
|
||
- PK: vendor_order_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): vendor_order_external_references(vendor_order_entity_id) [fk16n0vjl5dqid2b3q1q7jv2jrp]; vendor_file(order_id) [fk2sn16vflr7mjc9riwq7ee7fxk]; vendor_order_additional_info(vendor_order_entity_id) [fkeoruo4p69iln0k4f6ovod6my3]; vendor_order_entity_service_ids(vendor_order_entity_id) [fkhh2skywan2uev483rj1gye45b]; vendor_order_entity_required_service_info(vendor_order_entity_id) [fkneogvedbrwyxf523kexb0wvh8]; plate_submission(order_id) [fkp6b3ib0xl55upbyhk3fm15r1q]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_order_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (additional_info_id) -> additional_info(id) [fkb0qucuwj937qoftj3hhucilkl]; (vendor_order_entity_id) -> vendor_order(id) [fkeoruo4p69iln0k4f6ovod6my3]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_order_entity_required_service_info
|
||
- PK: vendor_order_entity_required_service_info_pkey: (vendor_order_entity_id, required_service_info_key)
|
||
- UK: 无
|
||
- FK(指向): (vendor_order_entity_id) -> vendor_order(id) [fkneogvedbrwyxf523kexb0wvh8]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_order_entity_service_ids
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (vendor_order_entity_id) -> vendor_order(id) [fkhh2skywan2uev483rj1gye45b]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_order_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (vendor_order_entity_id) -> vendor_order(id) [fk16n0vjl5dqid2b3q1q7jv2jrp]; (external_references_id) -> external_reference(id) [fkm75b25x59xcl6u06ovhqd4ag1]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec
|
||
- PK: vendor_spec_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): vendor_spec_additional_info(vendor_spec_entity_id) [fk85b7ucavy6aw04xlh2sq091xp]; vendor_spec_external_references(vendor_spec_entity_id) [fkhnqmgqyaofwey1vm3ly1kr46k]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_additional_info
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (vendor_spec_entity_id) -> vendor_spec(id) [fk85b7ucavy6aw04xlh2sq091xp]; (additional_info_id) -> additional_info(id) [fktpypusyxppcuv845ww67cxgly]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_deliverable
|
||
- PK: vendor_spec_deliverable_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_external_references
|
||
- PK: 无
|
||
- UK: 无
|
||
- FK(指向): (external_references_id) -> external_reference(id) [fkc3usn08w7ld6ii26stfy3acwn]; (vendor_spec_entity_id) -> vendor_spec(id) [fkhnqmgqyaofwey1vm3ly1kr46k]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_input_format
|
||
- PK: vendor_spec_input_format_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_platform
|
||
- PK: vendor_spec_platform_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): (standard_requirements_id) -> vendor_spec_requirement(id) [fk4jodgfv6misu1xqyo5j4285mm]
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_requirement
|
||
- PK: vendor_spec_requirement_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): vendor_spec_platform(standard_requirements_id) [fk4jodgfv6misu1xqyo5j4285mm]
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_sample_type
|
||
- PK: vendor_spec_sample_type_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_status
|
||
- PK: vendor_spec_status_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
### vendor_spec_well_position
|
||
- PK: vendor_spec_well_position_pkey: (id)
|
||
- UK: 无
|
||
- FK(指向): 无
|
||
- 被引用(来自): 无
|
||
- 显式索引: 无
|
||
- CHECK: 无
|
||
|
||
|