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)