Description
noneTable properties
| name | value |
|---|
| name | ml_server.ml_subscription |
| row count | |
| Maximum size of a single row | 300 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| rid | integer | 4 | | no
| composite PK
| ml_database.rid
|
| |
| subscription_id | varchar(128) | 128 | '<unknown>' | no
| composite PK
| |
| |
| user_id | integer | 4 | | no
|
| ml_user.user_id
|
| |
| progress | numeric(20,0) | 20 | 0 | no
|
| |
| |
| publication_name | varchar(128) | 128 | '<unknown>' | no
|
| |
| |
| last_upload_time | timestamp | 8 | '1900/01/01 00:00:00' | no
|
| |
| |
| last_download_time | timestamp | 8 | '1900/01/01 00:00:00' | no
|
| |
| |
References
Foreign key graph
Foreign keys
| name | columns | foreign columns | type | comment |
|---|
| ml_database | rid | ml_database.rid |
| |
| ml_user | user_id | ml_user.user_id |
| |
Dependency graph
Objects that depend on ml_server.ml_subscription
Code
CREATE TABLE "ml_server"."ml_subscription" (
"rid" integer NOT NULL
,"subscription_id" varchar(128) NOT NULL DEFAULT '<unknown>'
,"user_id" integer NOT NULL
,"progress" numeric(20,0) NOT NULL DEFAULT 0
,"publication_name" varchar(128) NOT NULL DEFAULT '<unknown>'
,"last_upload_time" timestamp NOT NULL DEFAULT '1900/01/01 00:00:00'
,"last_download_time" timestamp NOT NULL DEFAULT '1900/01/01 00:00:00'
,PRIMARY KEY ("rid","subscription_id")
)