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