Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('oc_share_id_seq'::regclass) |
|
|
||
| int2 | 5 | 0 |
|
|
||||
| varchar | 255 | √ | NULL::character varying |
|
|
|||
| password | varchar | 255 | √ | NULL::character varying |
|
|
||
| uid_owner | varchar | 64 | ''::character varying |
|
|
|||
| uid_initiator | varchar | 64 | √ | NULL::character varying |
|
|
||
| parent | int8 | 19 | √ | null |
|
|
||
| item_type | varchar | 64 | ''::character varying |
|
|
|||
| item_source | varchar | 255 | √ | NULL::character varying |
|
|
||
| item_target | varchar | 255 | √ | NULL::character varying |
|
|
||
| file_source | int8 | 19 | √ | null |
|
|
||
| file_target | varchar | 512 | √ | NULL::character varying |
|
|
||
| permissions | int2 | 5 | 0 |
|
|
|||
| stime | int8 | 19 | 0 |
|
|
|||
| accepted | int2 | 5 | 0 |
|
|
|||
| expiration | timestamp | 22 | √ | NULL::timestamp without time zone |
|
|
||
| token | varchar | 32 | √ | NULL::character varying |
|
|
||
| mail_send | int2 | 5 | 0 |
|
|
|||
| varchar | 64 | √ | NULL::character varying |
|
|
|||
| password_by_talk | bool | 1 | √ | false |
|
|
||
| note | text | 2147483647 | √ | null |
|
|
||
| hide_download | int2 | 5 | √ | 0 |
|
|
||
| label | varchar | 255 | √ | NULL::character varying |
|
|
||
| attributes | json | 2147483647 | √ | null |
|
|
||
| password_expiration_time | timestamp | 22 | √ | NULL::timestamp without time zone |
|
|
||
| reminder_sent | bool | 1 | √ | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_share_pkey | Primary key | Asc | id |
| file_source_index | Performance | Asc | file_source |
| initiator_index | Performance | Asc | uid_initiator |
| item_share_type_index | Performance | Asc/Asc | item_type + share_type |
| owner_index | Performance | Asc | uid_owner |
| parent_index | Performance | Asc | parent |
| share_with_index | Performance | Asc | share_with |
| token_index | Performance | Asc | token |