Schema packeis2.default

Table package_info

Column Summary
Name SqlType Length Precision Scale Nullable Unique
id integer 255 19 2 false true
version integer 255 19 2 true false
name varchar(45) 45 19 2 false false
archive_name varchar(45) 45 19 2 false false
short_description varchar(60) 60 19 2 false false
author varchar(45) 45 19 2 false false
package_version varchar(45) 45 19 2 false false
date date 10 19 2 false false
state varchar(8) 8 19 2 false false
sha1sum varchar(45) 45 19 2 true false
required_space varchar(45) 45 19 2 true false
description longtext 65'535 19 2 true false
filesize integer 255 19 2 false false
official bit 255 19 2 false false
active bit 255 19 2 false false
marked_as_deleted bit 255 19 2 false false
on_cd bit 255 19 2 false false
packeis_state varchar(45) 45 19 2 false false
tree_entry_idfk integer 255 19 2 false false
owner_user_idfk integer 255 19 2 false false
checker_user_idfk integer 255 19 2 true false
Primary Key
Name Columns
PRIMARY id
Foreign Keys
Name Referenced Table Columns
packageFKowner_user user owner_user_idfk
FK901AA507D9BE694C tree_entry tree_entry_idfk
FK901AA5074B61A49 user owner_user_idfk
FK901AA507E63A1CCB user checker_user_idfk
packageFKtree_entry tree_entry tree_entry_idfk
packageFKchecker_user user checker_user_idfk
Unique Keys
Name Columns
PRIMARY id
Indexes
Name Columns
packageFKowner_user owner_user_idfk
packageFKtree_entry tree_entry_idfk
packageFKchecker_user checker_user_idfk

Column Detail

id

version

name

archive_name

short_description

author

package_version

date

state

sha1sum

required_space

description

filesize

official

active

marked_as_deleted

on_cd

packeis_state

tree_entry_idfk

owner_user_idfk

checker_user_idfk