sports

Tables (5)

Copy Of cmmn_code_detail (CopyOf공통코드상세)

  • cmmn_code_detail_pk (cmmn_code_seq) — INTEGER — Primary key — NOT NULL
  • cmmn_code_id — VARCHAR(20)
  • cmmn_code_detail_nm — VARCHAR(40)
  • cmmn_code_sn — INTEGER
  • extra_ccode_0 (extra_code_0) — VARCHAR(20)
  • extra_code_1 — VARCHAR(20)
  • extra_code_2 — VARCHAR(20)
  • use_at — SMALLINT
  • abrv — VARCHAR(128)
  • regist_date — DATETIME
  • regist_mber — INTEGER
  • updt_date — DATETIME
  • updt_mber — INTEGER
  • delete_date — DATETIME
  • delete_mber — INTEGER

cmmn_code (공통코드)

  • cmmn_code_pk (cmmn_code_seq) — INTEGER — Primary key — NOT NULL
  • cmmn_code_id — VARCHAR(20)
  • cmmn_code_nm — VARCHAR(40)
  • rm — VARCHAR(40)
  • regist_date — DATETIME
  • regist_mber — INTEGER
  • Field (updt_date) — DATETIME
  • Field (updt_mber) — INTEGER
  • Field (delete_date) — DATETIME
  • Field (delete_mber) — INTEGER

cmmn_code_detail (공통코드상세)

  • cmmn_code_detail_pk (cmmn_code_seq) — INTEGER — Primary key — NOT NULL
  • cmmn_code_id — VARCHAR(20)
  • cmmn_code_detail_nm — VARCHAR(40)
  • cmmn_code_sn — INTEGER
  • extra_ccode_0 (extra_code_0) — VARCHAR(20)
  • extra_code_1 — VARCHAR(20)
  • extra_code_2 — VARCHAR(20)
  • use_at — SMALLINT
  • abrv — VARCHAR(128)
  • regist_date — DATETIME
  • regist_mber — INTEGER
  • updt_date — DATETIME
  • updt_mber — INTEGER
  • delete_date — DATETIME
  • delete_mber — INTEGER

mber_author_group (회원권한그룹정보)

  • mber_info_pk — INTEGER — Primary key — NOT NULL
  • Field (author_group_id) — VARCHAR(20)
  • Field2 (perm_ip0) — VARCHAR(64)
  • Field3 (perm_ip1) — VARCHAR(64)
  • Field (regist_date) — DATETIME
  • Field (regist_mber) — INTEGER
  • Field (updt_date) — DATETIME
  • Field (updt_mber) — INTEGER
  • Field (delete_date) — DATETIME
  • Field (delete_mber) — INTEGER

mber_info (회원 관리)

  • mber_info_pk — INTEGER — Primary key — NOT NULL
  • Field (mber_id) — VARCHAR(30)
  • Field2 (mber_nm) — VARCHAR(10)
  • Field3 (password) — VARCHAR(100)
  • Field4 (password_encpt_at) — SMALLINT
  • Field5 (password_updt_date) — DATETIME
  • Field6 (password_updt_mber) — INTEGER
  • Field7 (brthdy) — DATETIME
  • Field8 (sexdstn) — SMALLINT
  • Field9 (moblphon_0) — VARCHAR(20)
  • Field10 (moblphon_1) — VARCHAR(20)
  • Field11 (moblphon_2) — VARCHAR(20)
  • Field (telno_0) — VARCHAR(20)
  • Field (telno_1) — VARCHAR(20)
  • Field (telno_2) — VARCHAR(20)
  • Field (email0) — VARCHAR(100)
  • Field (email1) — VARCHAR(100)
  • Field (acdmcr) — TEXT
  • Field (career) — TEXT
  • Field (ltrry_nd_thesis) — TEXT
  • Field2 (etc) — TEXT
  • Field (mber_sttus) — SMALLINT
  • Field (file_id) — VARCHAR(30)
  • Field (sms_recptn_at) — SMALLINT
  • Field (sms_recptn_change_date) — DATETIME
  • Field (email_recptn_at) — SMALLINT
  • Field (email_recptn_change_date) — DATETIME
  • Field (login_date) — DATETIME
  • Field (login_failr_co) — SMALLINT
  • Field (self_crtfc_cnnc_info) — VARCHAR(200)
  • Field (self_crtfc_dplct_info) — VARCHAR(200)
  • Field (ipin) — VARCHAR(200)
  • Field (confm_sttus) — SMALLINT
  • Field (confm_date) — DATETIME
  • (confm_mber) — INTEGER
  • Field (regist_date) — DATETIME
  • Field (regist_mber) — INTEGER
  • Field (updt_date) — DATETIME
  • Field (updt_mber) — INTEGER
  • Field (delete_date) — DATETIME
  • Field (delete_mber) — INTEGER
  • Field (secsn_date) — DATETIME
  • Field (secsn_mber) — INTEGER