한능검_as-is_물리ERD_test

테이블 (21)

tb_co_pst_20160225

  • pst_sno — numeric(15,0) — NOT NULL
  • bbs_id — character varying(20)
  • pst_title — character varying(300)
  • pst_cntn — character varying(1073741823)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • crtn_user_nm — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • lst_chng_user_nm — character varying(50)
  • anoc_yn — character(1)
  • eml — character varying(100)
  • rtrv_fig — numeric(15,0)
  • pst_ds — character(1)
  • supt_ds — character(2)
  • req_num — character varying(10)
  • req_grade — numeric(15,0)
  • req_no — character varying(20)
  • mntrm — character varying(255)
  • basis — character varying(255)
  • cnsr — character varying(10)
  • cnsr_rate — character varying(10)
  • explna — character varying(1000)
  • period — character(2)
  • fld — character(1)
  • allot — numeric(15,0)
  • ldfcy — character(1)
  • quest_cls — character(1)
  • use_yn — character(1)
  • as_is_idx — character varying(20)

tok_bbs

  • bbs_id — character varying(20) — NOT NULL
  • bbs_nm — character varying(300)
  • intro — character varying(8000)
  • bbs_ds — character(1)
  • use_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • file_use_yn — character(1)
  • atch_psb_fig — numeric(1,0)
  • anoc_use_yn — character(1)

tok_co_auth

  • auth_id — character varying(20) — NOT NULL
  • auth_nm — character varying(50)
  • auth_cntn — character varying(1000)
  • use_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_co_auth_clsfn_rl

  • auth_id — character varying(20) — NOT NULL
  • clsfn_id — character varying(20) — NOT NULL
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_code

  • cd_grp_id — character varying(50) — NOT NULL
  • cd_id — character varying(20) — NOT NULL
  • cd_nm — character varying(300)
  • cd_exp — character varying(600)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • sort_seq — numeric(3,0)

tok_code_group

  • cd_grp_id — character varying(50) — NOT NULL
  • cd_grp_nm — character varying(300)
  • cd_grp_exp — character varying(600)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_exam

  • pst_sno — numeric(15,0) — NOT NULL
  • bbs_id — character varying(20)
  • pst_title — character varying(300)
  • pst_cntn — character varying(1073741823)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • crtn_user_nm — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • lst_chng_user_nm — character varying(50)
  • anoc_yn — character varying(2)
  • eml — character varying(100)
  • rtrv_fig — numeric(15,0)
  • pst_ds — character(1)
  • supt_ds — character(2)
  • req_num — character varying(10)
  • req_grade — character(1)
  • req_no — character varying(20)
  • mntrm — character varying(255)
  • basis — character varying(255)
  • cnsr — character varying(10)
  • cnsr_rate — character varying(10)
  • explna — character varying(1000)
  • period — character(2)
  • fld — character(1)
  • allot — numeric(15,0)
  • ldfcy — character(1)
  • quest_cls — character(1)
  • use_yn — character(1)
  • as_is_idx — character varying(20)
  • etctext — character varying(2000)
  • rate2 — character varying(100)
  • disabledperson — character varying(500)

tok_exam_acpt_level

  • times — numeric(10,0) — NOT NULL
  • acpt_level — numeric(5,0) — NOT NULL
  • acpt_level_nm — character varying(20) — NOT NULL
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_exam_answer

  • id — integer — NOT NULL
  • reg_date — datetime
  • req_num — integer
  • req_grade — integer
  • status — integer

tok_exam_answer_detail

  • answer_id — integer — NOT NULL
  • req_no — integer — NOT NULL
  • answer — integer — NOT NULL
  • reg_date — datetime

tok_exam_file

  • atch_file_id — character varying(20) — NOT NULL
  • pst_sno — numeric(15,0)
  • pst_seq — numeric(15,0)
  • upload_path — character varying(6000)
  • phsc_file_nm — character varying(800)
  • logc_file_nm — character varying(800)
  • ext — character varying(60)
  • file_size — numeric(15,0)
  • file_down_fig — numeric(15,0)
  • pst_type — character(1)

tok_exam_file_old

  • atch_file_id — character varying(20) — NOT NULL
  • pst_sno — numeric(15,0)
  • pst_seq — numeric(15,0)
  • upload_path — character varying(6000)
  • phsc_file_nm — character varying(800)
  • logc_file_nm — character varying(800)
  • ext — character varying(60)
  • file_size — numeric(15,0)
  • file_down_fig — numeric(15,0)
  • pst_type — character(1)

tok_exam_pool

  • exam_sno — numeric(15,0) — NOT NULL
  • exam_title — character varying(300)
  • exam_times — numeric(15,0) — NOT NULL
  • exam_grade — numeric(2,0) — NOT NULL
  • exam_no — numeric(2,0) — NOT NULL
  • exam_mntrm — character varying(1000)
  • exam_basis — character varying(1000)
  • exam_cnsr — character varying(100)
  • exam_cnsr_rate — character varying(100)
  • exam_cnsr_rate2 — character varying(100)
  • exam_explna — character varying(1000)
  • exam_period — character(2)
  • exam_fld — character(1)
  • exam_allot — numeric(3,0)
  • exam_ldfcy — character(1)
  • exam_quest_cls — character(1)
  • exam_cntntext — character varying(4096)
  • exam_disabledperson — character varying(4096)
  • use_yn — character(1)
  • anoc_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • crtn_user_nm — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • lst_chng_user_nm — character varying(50)
  • exam_old_grade — numeric(2,0)
  • as_is_idx — character varying(20)

tok_exam_pool_20160301

  • exam_sno — numeric(15,0) — NOT NULL
  • exam_title — character varying(300)
  • exam_times — numeric(15,0) — NOT NULL
  • exam_grade — numeric(2,0) — NOT NULL
  • exam_no — numeric(2,0) — NOT NULL
  • exam_mntrm — character varying(1000)
  • exam_basis — character varying(1000)
  • exam_cnsr — character varying(100)
  • exam_cnsr_rate — character varying(100)
  • exam_cnsr_rate2 — character varying(100)
  • exam_explna — character varying(1000)
  • exam_period — character(2)
  • exam_fld — character(1)
  • exam_allot — numeric(3,0)
  • exam_ldfcy — character(1)
  • exam_quest_cls — character(1)
  • exam_cntntext — character varying(4096)
  • exam_disabledperson — character varying(4096)
  • use_yn — character(1)
  • anoc_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • crtn_user_nm — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • lst_chng_user_nm — character varying(50)
  • exam_old_grade — numeric(2,0)
  • as_is_idx — character varying(20)

tok_exam_pool_answer

  • seq — integer — NOT NULL
  • times — integer — NOT NULL
  • grade — integer — NOT NULL
  • status — integer
  • reg_ip — character varying(20)
  • reg_date — character(14)

tok_manager

  • idx — numeric(10,0) — NOT NULL
  • mngr_id — character varying(50) — NOT NULL
  • mngr_pw — character varying(600) — NOT NULL
  • mngr_nm — character varying(500) — NOT NULL
  • mngr_level — character varying(10) — NOT NULL
  • conect_rstc_yn — character(1)
  • conect_ip — character varying(50)
  • dstrct_id — character varying(20)
  • use_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)
  • tlno — character varying(20)
  • eml — character varying(100)
  • ipin_dupcode — character varying(255)
  • pwd_edit_date — character varying(14)

tok_manager_auth

  • mngr_id — character varying(50) — NOT NULL
  • auth_id — character varying(20) — NOT NULL
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_manager_login

  • lgin_sno — numeric(10,0) — NOT NULL
  • lgin_id — character varying(50)
  • lgin_ip — character varying(50)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_menu

  • clsfn_id — character varying(20) — NOT NULL
  • prnt_clsfn_id — character varying(20)
  • clsfn_nm — character varying(300)
  • clsfn_detl — character varying(1000)
  • clsfn_lvl — numeric(2,0)
  • url — character varying(1000)
  • sort_seq — numeric(3,0)
  • use_yn — character(1)
  • crtn_dtm — character(14)
  • crtn_user_id — character varying(50)
  • lst_chng_dtm — character(14)
  • lst_chng_user_id — character varying(50)

tok_show_exam

  • req_grade — integer — NOT NULL
  • req_num — integer — NOT NULL

tok_show_exam_pool

  • exam_times — integer — NOT NULL
  • exam_grade — integer — NOT NULL