Schema packeis2.default
Table package_info
Primary Key
|
Name
|
Columns
|
PRIMARY
|
id
|
Unique Keys
|
Name
|
Columns
|
PRIMARY
|
id
|
Column Detail
id
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: true
-
Comment:
version
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment: For hibernate optimistic lock mechanics
name
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
archive_name
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
short_description
-
Type: varchar(60)
-
Length: 60
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: has lucene index
author
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: has lucene index
package_version
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: has lucene index
date
-
Type: date
-
Length: 10
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: has lucene index
state
-
Type: varchar(8)
-
Length: 8
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: has lucene index
sha1sum
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
required_space
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
description
-
Type: longtext
-
Length: 65'535
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
filesize
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
official
-
Type: bit
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
active
-
Type: bit
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
marked_as_deleted
-
Type: bit
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
on_cd
-
Type: bit
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
packeis_state
-
Type: varchar(45)
-
Length: 45
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
tree_entry_idfk
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: Section ID corresponds to a tree entry
owner_user_idfk
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
checker_user_idfk
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment: