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 — =