TSNLP Database Schema


Following is the TSNLP database schema as an abstract entity-relationship diagram together with more detailed information on the relations involved (see below); the diagram is mouse-sensitive such that you can look up the details of a token relation (i.e. its attribute names and types) by clicking on it:


Basic Entity Types


item
i-id :integer :key
i-origin :string
i-register :string
i-format :string
i-difficulty :integer
i-category :string
i-input :string
i-wf :integer
i-length :integer
i-comment :string
i-author :string
i-date :string


analysis
i-id :integer :key
a-position :position
a-instance :string
a-category :string
a-function :string
a-domain :string
a-tag :string
a-comment :string


phenomenon
p-id :integer :key
p-name :string
p-supertypes :string
p-presupposition :string
p-interaction :string
p-purpose :string
p-restrictions :string
p-comment :string
p-author :string
p-date :string


parameter
ip-id :integer :key
position :string
attribute :string
value :string
instance :string
comment :string


set
s-id :integer :key
p-id :integer :key
s-author :string
s-date :string


Relationship Types


item-phenomenon
ip-id :integer :key
i-id :integer :key
p-id :integer :key
ip-author :string
ip-date :string


item-set
i-id :integer :key
s-id :integer :key
polarity :integer


[
database schema] [new query] [sample queries] [TSNLP home] [CL home]
last modified: 20-sep-95 (oe@cl.dfki.uni-sb.de)