tradingSite
Tables (12)
Untitled (검수기준)
- Key (spec_code) — VARCHAR(20) — Primary key — NOT NULL
- Field (spec_title) — VARCHAR(100)
- Field2 (spec_sub_title) — VARCHAR(200)
- Field3 (spec_content) — VARCHAR(5000)
- Field (cmm_code) — VARCHAR(20)
- Field (spec_use_yn) — VARCHAR(1)
Untitled (1(사용자) : N(체크))
- Key (user_code) — VARCHAR(20) — Primary key — NOT NULL
- Key2 (cmm_code) — VARCHAR(20) — Primary key — NOT NULL
- Field (check_yn) — VARCHAR(1)
tb_annm (공지사항)
- annm_code — VARCHAR(20) — Primary key — NOT NULL
- annm_title — VARCHAR(100)
- annm_sub_title — VARCHAR(200)
- annm_content — VARCHAR(5000)
- cmm_code — VARCHAR(20)
- file_code — VARCHAR(200)
- annm_use_yn — VARCHAR(1)
tb_auth (권한)
- auth_code — VARCHAR(20) — Primary key — NOT NULL
- auth_name — VARCHAR(500)
- auth_use_yn — VARCHAR(1)
tb_auth_menu_mapping (1(권한) : N(메뉴))
- auth_code — VARCHAR(20) — Primary key — NOT NULL
- menu_code — VARCHAR(20) — Primary key — NOT NULL
- create_yn — VARCHAR(1)
- update_yn — VARCHAR(1)
- read_yn — VARCHAR(1)
- delete_yn — VARCHAR(1)
tb_cmm_code (공통코드)
- cmm_code — VARCHAR(20) — Primary key — NOT NULL
- cmm_level_0_code — VARCHAR(20)
- cmm_level_0_name — VARCHAR(500)
- cmm_level_1_code — VARCHAR(20)
- cmm_level_1_name — VARCHAR(500)
- cmm_level_2_code — VARCHAR(20)
- cmm_level_2_name — VARCHAR(500)
- cmm_decription — VARCHAR(500)
- cmm_use_yn — VARCHAR(1)
tb_faq (자주묻는질문)
- faq_code — VARCHAR(20) — Primary key — NOT NULL
- faq_title — VARCHAR(100)
- faq_sub_title — VARCHAR(200)
- faq_content — VARCHAR(5000)
- cmm_code — VARCHAR(20)
- file_code — VARCHAR(20)
- faq_use_yn — VARCHAR(1)
tb_file (파일)
- file_code — VARCHAR(20) — Primary key — NOT NULL
- file_name — VARCHAR(500)
- file_save_path — VARCHAR(100)
- file_save_name — VARCHAR(100)
- file_ext — VARCHAR(20)
tb_menu (메뉴)
- menu_code — VARCHAR(20) — Primary key — NOT NULL
- upper_menu_code — VARCHAR(20)
- menu_name — VARCHAR(500)
- menu_order — INT(11)
- menu_use_yn — VARCHAR(1)
tb_product (상품)
- product_code — VARCHAR(20) — Primary key — NOT NULL
- product_name — VARCHAR(500)
- product_price — INT(11)
- product_state — VARCHAR(20)
- cmm_code — VARCHAR(20)
- product_decription (cmm_decription) — VARCHAR(500)
- product_use_yn — VARCHAR(1)
tb_seq (시퀀스)
- seq_table_name — VARCHAR(20) — Primary key — NOT NULL
- seq_idx — INT(11)
tb_users (사용자)
- user_code — VARCHAR(20) — Primary key — NOT NULL
- user_id — VARCHAR(20)
- user_pw — VARCHAR(500)
- auth_code — VARCHAR(20)
- user_lock_yn — VARCHAR(1)
- user_login_cnt — INT(1)
- user_use_yn — VARCHAR(1)