study_details_cached
| Column |
Type |
PK |
Required |
Default |
| tenant_id |
TEXT |
No |
No |
|
| study_id |
TEXT |
No |
No |
|
| study_name |
TEXT |
No |
No |
|
| study_description |
TEXT |
No |
No |
|
| start_date |
TEXT |
No |
No |
|
| end_date |
TEXT |
No |
No |
|
| nct_number |
TEXT |
No |
No |
|
| total_number_of_participants |
|
No |
No |
|
| average_age |
|
No |
No |
|
| percentage_of_females |
|
No |
No |
|
| investigators |
|
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE study_details_cached(
tenant_id TEXT,
study_id TEXT,
study_name TEXT,
study_description TEXT,
start_date TEXT,
end_date TEXT,
nct_number TEXT,
total_number_of_participants,
average_age,
percentage_of_females,
investigators
)