한능검_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