source: ruby/trunk/db/test.sqlite3

Last change on this file was 420, checked in by KOBAYASHI, Shinji, 14 years ago

implementing terminology related tables
  • Property svn:mime-type set to application/octet-stream
File size: 12.0 KB
Line 
1SQLite format 3@ û û¨¤P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚''ƒKtableterminologiesterminologiesCREATE TABLE "terminologies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "name" varchar(255), "lang" varchar(255), "group" text, "rubric" varchar(255), "description" text, "mappings" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT
2¦îÜʸ¦)20100705082838)20100705070022)20100702073455)20100129010414)20090725052538
3¡íÚÇ´¡)20100705082838)20100705070022)20100702073455)20100129010414)20090725052538
4
5ºìÚº
6;terminology_identifiersÁ‡#languages:l†ò#territories,½Õ
7
8\\ÏYb´Xq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")‚''ƒKtableterminologiesterminologiesCREATE TABLE "terminologies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "name" varchar(255), "lang" varchar(255), "group" text, "rubric" varchar(255), "description" text, "mappings" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚I))„Mtablearchetype_dataarchetype_dataCREATE TABLE "archetype_data" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "oid" varchar(255), "archetype_id" varchar(255), "concept" varchar(255), "path" varchar(255), "text_data" varchar(255), "integer_data" integer, "real_data" float, "created_at" datetime, "updated_at" datetime)
9×ì׃ӲrafAfrikaansŽª”f
10sqAlbanian
11''ÖC¸Y##‚ytableterritoriesterritories
12CREATE TABLE "territories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NO,‚'tablelanguageslanguagesCREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "description" varchar(255) NOT NULL)k; indexindex_languages_on_codelanguages
13CREATE INDEX "index_languages_on_code" ON "languages" ("code")Y##‚ytableterritoriesterritories
14CREATE TABLE "territories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" varchar(255), "three_letter" varchar(255), "numeric_code" varchar(255), "two_letter" varchar(255))^ ;;‚Stableterminology_identifiersterminology_identifiers
15CREATE TABLE "terminology_identifiers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vsab" varchar(255), "authority" varchar(255), "source_name" varchar(255))
16ììö af:l†ò sqʊf
17¨ã¨5‚ä¶ûU[Albania, People's Socialist Republic ofALB008AL‚áÞã#AfghanistanAFG4AF
18œœÙ8î¿¢K!QALT2000UMLS2003AAAlternative Billing Concepts, 2000!Þ†Ž#!'AIR93UMLS2003AAAI/RHEUM,1993
Note: See TracBrowser for help on using the repository browser.