about summary refs log tree commit diff stats
path: root/schema.sql
diff options
context:
space:
mode:
authorKelly Rauchenberger <fefferburbia@gmail.com>2016-03-16 21:35:35 -0400
committerKelly Rauchenberger <fefferburbia@gmail.com>2016-03-16 21:35:35 -0400
commit8b1333d0e6e2b9a5014bdbff2987d899f5413fee (patch)
treeab5c864b61cab267ad3118e8cbe637c151448aa5 /schema.sql
parent3aceae8ab1eb5992110ea57a9479bbc3177feb21 (diff)
downloadfurries-8b1333d0e6e2b9a5014bdbff2987d899f5413fee.tar.gz
furries-8b1333d0e6e2b9a5014bdbff2987d899f5413fee.tar.bz2
furries-8b1333d0e6e2b9a5014bdbff2987d899f5413fee.zip
Added word derivational relationships (kind of eh at the moment) and moved verbly into its own directory
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql204


1 files changed, 0 insertions, 204 deletions
diff --git a/schema.sql b/schema.sql
deleted file mode 100644
index fd55734..0000000
--- a/schema.sql
+++ /dev/null

@@ -1,204 +0,0 @@

1DROP TABLE IF EXISTS `verbs`;


2CREATE TABLE `verbs` (


3  `verb_id` INTEGER PRIMARY KEY,


4  `infinitive` VARCHAR(32) NOT NULL,


5  `past_tense` VARCHAR(32) NOT NULL,


6  `past_participle` VARCHAR(32) NOT NULL,


7  `ing_form` VARCHAR(32) NOT NULL,


8  `s_form` VARCHAR(32) NOT NULL


9);


10


11DROP TABLE IF EXISTS `groups`;


12CREATE TABLE `groups` (


13  `group_id` INTEGER PRIMARY KEY,


14  `parent_id` INTEGER,


15  FOREIGN KEY (`parent_id`) REFERENCES `groups`(`group_id`)


16);


17


18DROP TABLE IF EXISTS `frames`;


19CREATE TABLE `frames` (


20  `frame_id` INTEGER PRIMARY KEY,


21  `group_id` INTEGER NOT NULL,


22  `data` BLOB NOT NULL,


23  FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)


24);


25


26DROP TABLE IF EXISTS `verb_groups`;


27CREATE TABLE `verb_groups` (


28  `verb_id` INTEGER NOT NULL,


29  `group_id` INTEGER NOT NULL,


30  FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`),


31  FOREIGN KEY (`group_id`) REFERENCES `groups`(`group_id`)


32);


33


34DROP TABLE IF EXISTS `adjectives`;


35CREATE TABLE `adjectives` (


36  `adjective_id` INTEGER PRIMARY KEY,


37  `base_form` VARCHAR(32) NOT NULL,


38  `comparative` VARCHAR(32),


39  `superlative` VARCHAR(32),


40  `position` CHAR(1)


41);


42


43DROP TABLE IF EXISTS `adverbs`;


44CREATE TABLE `adverbs` (


45  `adverb_id` INTEGER PRIMARY KEY,


46  `base_form` VARCHAR(32) NOT NULL,


47  `comparative` VARCHAR(32),


48  `superlative` VARCHAR(32)


49);


50


51DROP TABLE IF EXISTS `nouns`;


52CREATE TABLE `nouns` (


53  `noun_id` INTEGER PRIMARY KEY,


54  `singular` VARCHAR(32) NOT NULL,


55  `plural` VARCHAR(32)


56);


57


58DROP TABLE IF EXISTS `hypernymy`;


59CREATE TABLE `hypernymy` (


60  `hypernym_id` INTEGER NOT NULL,


61  `hyponym_id` INTEGER NOT NULL,


62  FOREIGN KEY (`hypernym_id`) REFERENCES `nouns`(`noun_id`),


63  FOREIGN KEY (`hyponym_id`) REFERENCES `nouns`(`noun_id`)


64);


65


66DROP TABLE IF EXISTS `instantiation`;


67CREATE TABLE `instantiation` (


68  `class_id` INTEGER NOT NULL,


69  `instance_id` INTEGER NOT NULL,


70  FOREIGN KEY (`class_id`) REFERENCES `nouns`(`noun_id`),


71  FOREIGN KEY (`instance_id`) REFERENCES `nouns`(`noun_id`)


72);


73


74DROP TABLE IF EXISTS `member_meronymy`;


75CREATE TABLE `member_meronymy` (


76  `meronym_id` INTEGER NOT NULL,


77  `holonym_id` INTEGER NOT NULL,


78  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),


79  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)


80);


81


82DROP TABLE IF EXISTS `part_meronymy`;


83CREATE TABLE `part_meronymy` (


84  `meronym_id` INTEGER NOT NULL,


85  `holonym_id` INTEGER NOT NULL,


86  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),


87  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)


88);


89


90DROP TABLE IF EXISTS `substance_meronymy`;


91CREATE TABLE `substance_meronymy` (


92  `meronym_id` INTEGER NOT NULL,


93  `holonym_id` INTEGER NOT NULL,


94  FOREIGN KEY (`meronym_id`) REFERENCES `nouns`(`noun_id`),


95  FOREIGN KEY (`holonym_id`) REFERENCES `nouns`(`noun_id`)


96);


97


98DROP TABLE IF EXISTS `variation`;


99CREATE TABLE `variation` (


100  `noun_id` INTEGER NOT NULL,


101  `adjective_id` INTEGER NOT NULL,


102  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),


103  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)


104);


105


106DROP TABLE IF EXISTS `noun_antonymy`;


107CREATE TABLE `noun_antonymy` (


108  `noun_1_id` INTEGER NOT NULL,


109  `noun_2_id` INTEGER NOT NULL,


110  FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`noun_id`),


111  FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`noun_id`)


112);


113


114DROP TABLE IF EXISTS `adjective_antonymy`;


115CREATE TABLE `adjective_antonymy` (


116  `adjective_1_id` INTEGER NOT NULL,


117  `adjective_2_id` INTEGER NOT NULL,


118  FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),


119  FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)


120);


121


122DROP TABLE IF EXISTS `adverb_antonymy`;


123CREATE TABLE `adverb_antonymy` (


124  `adverb_1_id` INTEGER NOT NULL,


125  `adverb_2_id` INTEGER NOT NULL,


126  FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),


127  FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)


128);


129


130DROP TABLE IF EXISTS `specification`;


131CREATE TABLE `specification` (


132  `general_id` INTEGER NOT NULL,


133  `specific_id` INTEGER NOT NULL,


134  FOREIGN KEY (`general_id`) REFERENCES `adjectives`(`adjective_id`),


135  FOREIGN KEY (`specific_id`) REFERENCES `adjectives`(`adjective_id`)


136);


137


138DROP TABLE IF EXISTS `pertainymy`;


139CREATE TABLE `pertainymy` (


140  `noun_id` INTEGER NOT NULL,


141  `pertainym_id` INTEGER NOT NULL,


142  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`),


143  FOREIGN KEY (`pertainym_id`) REFERENCES `adjectives`(`adjective_id`)


144);


145


146DROP TABLE IF EXISTS `mannernymy`;


147CREATE TABLE `mannernymy` (


148  `adjective_id` INTEGER NOT NULL,


149  `mannernym_id` INTEGER NOT NULL,


150  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`),


151  FOREIGN KEY (`mannernym_id`) REFERENCES `adverbs`(`adverb_id`)


152);


153


154DROP TABLE IF EXISTS `noun_synonymy`;


155CREATE TABLE `noun_synonymy` (


156  `noun_1_id` INTEGER NOT NULL,


157  `noun_2_id` INTEGER NOT NULL,


158  FOREIGN KEY (`noun_1_id`) REFERENCES `nouns`(`nouns_id`),


159  FOREIGN KEY (`noun_2_id`) REFERENCES `nouns`(`nouns_id`)


160);


161


162DROP TABLE IF EXISTS `adjective_synonymy`;


163CREATE TABLE `adjective_synonymy` (


164  `adjective_1_id` INTEGER NOT NULL,


165  `adjective_2_id` INTEGER NOT NULL,


166  FOREIGN KEY (`adjective_1_id`) REFERENCES `adjectives`(`adjective_id`),


167  FOREIGN KEY (`adjective_2_id`) REFERENCES `adjectives`(`adjective_id`)


168);


169


170DROP TABLE IF EXISTS `adverb_synonymy`;


171CREATE TABLE `adverb_synonymy` (


172  `adverb_1_id` INTEGER NOT NULL,


173  `adverb_2_id` INTEGER NOT NULL,


174  FOREIGN KEY (`adverb_1_id`) REFERENCES `adverbs`(`adverb_id`),


175  FOREIGN KEY (`adverb_2_id`) REFERENCES `adverbs`(`adverb_id`)


176);


177


178DROP TABLE IF EXISTS `noun_pronunciations`;


179CREATE TABLE `noun_pronunciations` (


180  `noun_id` INTEGER NOT NULL,


181  `pronunciation` VARCHAR(64) NOT NULL,


182  FOREIGN KEY (`noun_id`) REFERENCES `nouns`(`noun_id`)


183);


184


185DROP TABLE IF EXISTS `verb_pronunciations`;


186CREATE TABLE `verb_pronunciations` (


187  `verb_id` INTEGER NOT NULL,


188  `pronunciation` VARCHAR(64) NOT NULL,


189  FOREIGN KEY (`verb_id`) REFERENCES `verbs`(`verb_id`)


190);


191


192DROP TABLE IF EXISTS `adjective_pronunciations`;


193CREATE TABLE `adjective_pronunciations` (


194  `adjective_id` INTEGER NOT NULL,


195  `pronunciation` VARCHAR(64) NOT NULL,


196  FOREIGN KEY (`adjective_id`) REFERENCES `adjectives`(`adjective_id`)


197);


198


199DROP TABLE IF EXISTS `adverb_pronunciations`;


200CREATE TABLE `adverb_pronunciations` (


201  `adverb_id` INTEGER NOT NULL,


202  `pronunciation` VARCHAR(64) NOT NULL,


203  FOREIGN KEY (`adverb_id`) REFERENCES `adverbs`(`adverb_id`)


204);

 

generated by cgit-pink 1.4.1 (git 2.36.1) at 2024-11-21 18:23:11 +0000