eCTS
Tables (50)
c_revision_info
- rev — bigint — Primary key — NOT NULL
- timestamp — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
c_signature
- id — varchar(255) — Primary key — NOT NULL
- base64signature — varchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_adverse_reaction
- id — bigint — Primary key — NOT NULL
- action_taken — varchar(255)
- appearance_degree — int
- causal_relationship — varchar(255)
- end_date — datetime2(7)
- is_sae — bit — NOT NULL
- item — varchar(255)
- name — varchar(255)
- opinion — varchar(255)
- prediction_sae — int
- result — varchar(255)
- start_date — datetime2(7)
- subject_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_blood_chemistry_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_blood_clotting_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_blood_collection
- id — bigint — Primary key — NOT NULL
- date — datetime2(7)
- opinion — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_demography
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — varchar(255)
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_drug_administration
- id — bigint — Primary key — NOT NULL
- date — datetime2(7)
- opinion — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_electrocardiogram
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_exclusion_standard
- id — bigint — Primary key — NOT NULL
- answer — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- subject_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_hematology_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_interview
- id — bigint — Primary key — NOT NULL
- answer — int
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result_date — datetime2(7)
- result_text — varchar(255)
- unit — varchar(255)
- subject_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_other_inspection
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_physical
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- test_date — datetime2(7)
- subject_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_pre_concomitant_medications
- id — bigint — Primary key — NOT NULL
- dosage — bigint
- end_date — datetime2(7)
- frequency — varchar(255)
- is_keep_going — int
- item — varchar(255)
- opinion — varchar(255)
- reason — varchar(255)
- route — varchar(255)
- start_date — datetime2(7)
- unit — varchar(255)
- subject_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_pregnancy_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_serological_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — Foreign key → ssa_subject_visit.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_surgical_medical_history
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- end_date — datetime2(7)
- init_diagnosis_date — datetime2(7)
- is_keep_going — bit — NOT NULL
- item — varchar(255)
- opinion — varchar(255)
- subject_id — bigint — Foreign key → ssa_subject.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_urine_test
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — Foreign key → ssa_subject_visit.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
data_vital_signs
- id — bigint — Primary key — NOT NULL
- clinical_judgment_type — varchar(255)
- item — varchar(255)
- opinion — varchar(255)
- result — bigint
- test_date — datetime2(7)
- unit — varchar(255)
- subject_visit_id — bigint — Foreign key → ssa_subject_visit.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_category
- id — varchar(40) — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- deleted — bit
- name — nvarchar(255) — NOT NULL
- short_name — varchar(10) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_category_audit
- id — varchar(40) — Primary key — NOT NULL
- rev — bigint — Primary key — NOT NULL
- revtype — smallint
- deleted — bit
- deleted_changed — bit
- name — nvarchar(255)
- name_changed — bit
- short_name — varchar(10)
- short_name_changed — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_notice
- id — int — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- content — nvarchar(max) — NOT NULL
- deleted — bit
- status — varchar(255)
- title — nvarchar(255) — NOT NULL
- top_view_end_date — datetime2(7)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_notice_attach_file
- id — varchar(255) — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- deleted — bit
- file_name — nvarchar(255) — NOT NULL
- file_size — bigint
- file_type — nvarchar(255) — NOT NULL
- original_file_name — nvarchar(255) — NOT NULL
- notice_id — int — Foreign key → s_notice.id
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_notice_attach_file_audit
- id — varchar(255) — Primary key — NOT NULL
- rev — bigint — Primary key — NOT NULL
- revtype — smallint
- deleted — bit
- deleted_changed — bit
- file_name — nvarchar(255)
- file_name_changed — bit
- file_size — bigint
- file_size_changed — bit
- file_type — nvarchar(255)
- file_type_changed — bit
- original_file_name — nvarchar(255)
- original_file_name_changed — bit
- notice_id — int
- notice_changed — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
s_notice_audit
- id — int — Primary key — NOT NULL
- rev — bigint — Primary key — NOT NULL
- revtype — smallint
- content — nvarchar(max)
- content_changed — bit
- deleted — bit
- deleted_changed — bit
- status — varchar(255)
- post_status_changed — bit
- title — nvarchar(255)
- title_changed — bit
- top_view_end_date — datetime2(7)
- top_view_end_date_changed — bit
- attach_files_changed — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_agreement
- id — bigint — Primary key — NOT NULL
- ext — varchar(5)
- file_name — nvarchar(255)
- file_size — bigint
- file_type — nvarchar(255)
- original_file_name — nvarchar(255)
- status — varchar(255)
- version — varchar(5)
- agreement_question_id — bigint — Foreign key → ssa_agreement_question.id — NOT NULL
- study_id — bigint — Foreign key → ssa_study.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_agreement_question
- id — bigint — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- description — varchar(200)
- question — nvarchar(max)
- status — varchar(255)
- title — varchar(255)
- version — varchar(5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_blood_point
- id — bigint — Primary key — NOT NULL
- after_bebore_type — varchar(255)
- hour — int
- min — int
- study_schedule_id — bigint — Foreign key → ssa_study_schedule.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_check_inspection
- id — bigint — Primary key — NOT NULL
- check_yn — varchar(255)
- item_id — bigint — Foreign key → ssa_inspection_name.id — NOT NULL
- schedule_id — bigint — Foreign key → ssa_study_schedule.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_detail_inspection
- id — bigint — Primary key — NOT NULL
- detail_inspection — varchar(255)
- detail_inspection_item — varchar(255) — NOT NULL
- unit — varchar(255) — NOT NULL
- check_inspection_id — bigint — Foreign key → ssa_check_inspection.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_detail_inspection_name_unit
- id — bigint — Primary key — NOT NULL
- detail_inspection — varchar(255)
- detail_inspection_item — varchar(255) — NOT NULL
- unit — varchar(255) — NOT NULL
- item_name_id — bigint — Foreign key → ssa_inspection_name.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_inspection_name
- id — bigint — Primary key — NOT NULL
- item_name — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_other_test
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- study_schedule_id — bigint — Foreign key → ssa_study_schedule.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_study
- id — bigint — Primary key — NOT NULL
- collect_end_date — datetime2(7)
- collect_start_date — datetime2(7)
- cro — varchar(255)
- description — varchar(200)
- exclusion_stardrad — nvarchar(max)
- interview — nvarchar(max)
- protocol_no — varchar(40)
- selection_stardrad — nvarchar(max)
- site — varchar(255)
- sponsor — varchar(255)
- study_name — varchar(100)
- study_no — varchar(40)
- study_status — varchar(255)
- test_end_date — datetime2(7)
- test_number — int — NOT NULL
- test_start_date — datetime2(7)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_study_schedule
- id — bigint — Primary key — NOT NULL
- end_date — datetime2(7)
- start_date — datetime2(7)
- title — varchar(255)
- schedule_manager_id — bigint — Foreign key → ssa_study_schedule_manager.id — NOT NULL
- is_screening — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_study_schedule_manager
- id — bigint — Primary key — NOT NULL
- study_id — bigint — Foreign key → ssa_study.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_study_user
- id — bigint — Primary key — NOT NULL
- use_yn — varchar(255)
- study_id — bigint — Foreign key → ssa_study.id — NOT NULL
- user_id — int — Foreign key → ssa_user.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_study_user_role
- id — bigint — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- assign_date — datetime2(7)
- remark — varchar(255)
- use_yn — varchar(255)
- roll_id — int — Foreign key → sst_role.id — NOT NULL
- study_user_id — bigint — Foreign key → ssa_study_user.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_subject
- id — bigint — Primary key — NOT NULL
- random_num — varchar(255)
- screen_num — varchar(255)
- study_id — bigint — Foreign key → ssa_study.id — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- interview_answer — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_subject_visit
- id — bigint — Primary key — NOT NULL
- leave_date — datetime2(7)
- visit_date — datetime2(7)
- schedule_id — bigint — Foreign key → ssa_study_schedule.id
- subject_id — bigint — Foreign key → ssa_subject.id — NOT NULL
- tablet_give_date — datetime2(7)
- tablet_return_date — datetime2(7)
- watch_give_date — datetime2(7)
- watch_return_date — datetime2(7)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_temp_subject
- id — bigint — Primary key — NOT NULL
- agree_date — datetime2(7)
- base64signature — varchar(max)
- name — varchar(255)
- study_id — bigint — Foreign key → ssa_study.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ssa_user
- id — int — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- account_expired_date — datetime2(7)
- account_non_locked — bit — NOT NULL
- company — nvarchar(50)
- credentials_expired_date — datetime2(7)
- dept_name — nvarchar(50)
- email — varchar(255)
- emp_no — varchar(100)
- enabled — bit — NOT NULL
- eng_name — varchar(255)
- is_create_study — bit
- kor_name — varchar(30)
- fail_cnt — int
- password — varchar(255)
- phone — varchar(255)
- receive_email — bit — NOT NULL
- team_name — nvarchar(50)
- token_expired — bit — NOT NULL
- user_status — varchar(255)
- user_type — varchar(255)
- username — varchar(40)
- duty — nvarchar(100)
- is_tab_login_authority — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_code_detail
- id — bigint — Primary key — NOT NULL
- detail_etc1 — nvarchar(250)
- detail_etc2 — nvarchar(250)
- detail_etc3 — nvarchar(250)
- detail_nm — nvarchar(250)
- detail_nm_eng — nvarchar(250)
- detail_no — nvarchar(50)
- remark — nvarchar(250)
- sort_no — int
- use_yn — varchar(255)
- mast_no — nvarchar(50) — Foreign key → sst_code_master.mast_no — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_code_master
- mast_no — nvarchar(50) — Primary key — NOT NULL
- manager_flag — bit — NOT NULL
- mast_desc — nvarchar(250)
- mast_nm — nvarchar(250)
- mast_nm_eng — nvarchar(250)
- remark — nvarchar(250)
- system_flag — nvarchar(50)
- use_yn — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_company
- id — int — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- company_name — varchar(50)
- company_type — varchar(255)
- remark — varchar(250)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_menu
- id — int — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- menu_desc — varchar(255)
- menu_flag — bit — NOT NULL
- menu_name — varchar(255) — NOT NULL
- remark — varchar(255)
- sort_no — int
- use_yn — varchar(255)
- parent_id — int — Foreign key → sst_menu.id
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_option
- option_no — nvarchar(50) — Primary key — NOT NULL
- manager_flag — bit — NOT NULL
- option_desc — nvarchar(250)
- remark — nvarchar(250)
- system_flag — nvarchar(50)
- use_yn — varchar(255)
- value_data — nvarchar(250)
- value_etc1 — nvarchar(250)
- value_etc2 — nvarchar(250)
- value_etc3 — nvarchar(250)
- value_type — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
sst_role
- id — int — Primary key — NOT NULL
- created_by — nvarchar(4000)
- created_by_id — int
- created_by_ip — nvarchar(20)
- created_date — datetime2(7)
- last_modified_by — nvarchar(4000)
- last_modified_by_id — int
- last_modified_by_ip — nvarchar(20)
- last_modified_date — datetime2(7)
- enabled — bit — NOT NULL
- role_desc — varchar(255)
- role_name — varchar(255) — NOT NULL
- role_type — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
subject_agreement
- id — bigint — Primary key — NOT NULL
- agree_date — datetime2(7)
- answer — nvarchar(max)
- base64signature — varchar(max)
- agreement_id — bigint — Foreign key → ssa_agreement.id — NOT NULL
- subject_id — bigint — Foreign key → ssa_subject.id — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =