Enter
Tables (19)
cnp_agree
- ag_id — tinyint — Primary key — NOT NULL
- ag_terms — text — NOT NULL — 약관
- ag_privacy — text — NOT NULL — 개인정보
- ag_car_guide — text — NOT NULL — 제3자
- ag_item_guide — text — NOT NULL
cnp_auth
- au_id — int — Primary key — NOT NULL — 고유번호
- au_name — varchar(30) — NOT NULL — 이름
- au_use — tinyint(1) — NOT NULL — 0: 미사용 , 1:사용
- au_order — int — NOT NULL — 순서
- au_cont — text — NOT NULL — 내용
cnp_auth_menu
- au_id — int — Primary key — NOT NULL — 권한고유번호
- rt_id — int — Primary key — NOT NULL — 메뉴고유번호
cnp_cate
- ca_id — int — Primary key — NOT NULL
- ca_type — varchar(20) — NOT NULL
- ca_name — varchar(255) — NOT NULL
- ca_key — varchar(100) — NOT NULL
- ca_order — int — NOT NULL
- ca_content — text — NOT NULL
cnp_category
- cc_id — int — Primary key — NOT NULL
- cc_type — varchar(10) — NOT NULL — 목록 타입
- cc_name — varchar(50) — NOT NULL — 목록명
- cc_content — varchar(255) — NOT NULL — 목록 태용
- cc_order — int — NOT NULL — 순서
cnp_certi
- ce_id — int — Primary key — NOT NULL
- ce_hp — varchar(20) — NOT NULL
- ce_rand — varchar(10) — NOT NULL
- ce_time — int — NOT NULL
- ce_memo — varchar(255) — NOT NULL
- ce_ok — tinyint(1) — NOT NULL
cnp_company
- cc_id — int — Primary key — NOT NULL
- cc_name — varchar(50) — NOT NULL — 상업자명
- cc_number — varchar(20) — NOT NULL — 사업자번호
- cc_tel — varchar(20) — NOT NULL — 전화번호
- cc_ceo — varchar(50) — NOT NULL — 대표자명
- cc_zip — varchar(6) — NOT NULL
- cc_addr1 — varchar(255) — NOT NULL
- cc_addr2 — varchar(255) — NOT NULL
- cc_addr3 — varchar(255) — NOT NULL
- cc_addr_jibeon — varchar(255) — NOT NULL
- cc_use — tinyint(1) — NOT NULL
- cc_datetime — datetime
cnp_config
- cf_id — tinyint(1) — Primary key — NOT NULL
- cf_info — text — NOT NULL
- icode_server_ip — varchar(20) — NOT NULL
- icode_id — varchar(20) — NOT NULL
- icode_pw — varchar(20) — NOT NULL
- icode_server_port — varchar(20) — NOT NULL
- send_phone — varchar(20) — NOT NULL
- sms5_demo_send — int — NOT NULL
- certi_date — date
cnp_enter
- vi_id — int — Primary key — NOT NULL
- cv_id — int — Primary key — NOT NULL — 방문정보 고유아이디
- ce_id — int — Primary key — NOT NULL — 출입정보 고유아이디
- vi_sdate — date
- vi_stime — varchar(2) — NOT NULL
- vi_sdatetime — int — NOT NULL
- vi_edate — date
- vi_etime — varchar(2) — NOT NULL
- vi_edatetime — int — NOT NULL
- vi_state — int — NOT NULL — 0출 , 1 : 입
- vi_content — text — NOT NULL
- vi_datetime — datetime
- cv_id (cv_id2) — int — Foreign key → cnp_visitor.cv_id — NOT NULL — 방문정보 고유아이디
cnp_file
- pf_id — int — Primary key — NOT NULL
- pf_type — varchar(20) — NOT NULL
- idx — int — NOT NULL
- pf_no — int — NOT NULL
- pf_source — varchar(255) — NOT NULL
- pf_file — varchar(255) — NOT NULL
- pf_content — varchar(255) — NOT NULL
- pf_order — int — NOT NULL
cnp_grmenu
- gr_id — tinyint — Primary key — NOT NULL — 고유번호
- gr_name — varchar(30) — NOT NULL — 이름
- gr_use — tinyint(1) — NOT NULL — 메뉴사용
- gr_order — int — NOT NULL — 메뉴순서
- gr_admin — tinyint(1) — NOT NULL
cnp_inout
- io_id — int — Primary key — NOT NULL
- vi_id — int — NOT NULL — 방문자아이디
- mb_id — varchar(50) — NOT NULL — 회원아이디
- io_type — tinyint — NOT NULL — 0:입 , 1:출
- io_sdate — datetime — 입출시간
- io_edate — datetime
- io_work — int — NOT NULL — 일한시간 출-입
cnp_member
- mb_no — int — Primary key — NOT NULL
- mb_id — varchar(30) — NOT NULL — 고유번호(전화번호)
- mb_pw — varchar(50) — NOT NULL
- mb_level — tinyint(1) — NOT NULL — 일반회원:2, 프로젝트 매니저 : 5, 관리자: 10
- mb_name — varchar(30) — NOT NULL
- mb_hp — varchar(20) — NOT NULL
- mb_certi — tinyint(1) — NOT NULL
- mb_email — varchar(100) — NOT NULL
- mb_birth — varchar(10) — NOT NULL — 생년월일-주민번호 앞자기 숫자만
- mb_birth2 — tinyint(1) — NOT NULL
- mb_position — varchar(50) — NOT NULL — 직책
- mb_lost_certify — varchar(255) — NOT NULL — 비밀번호변경 인증코드
- mb_lost_datetime — datetime
- cc_id — int — NOT NULL — 업체고유아이디
- cc_name — varchar(50) — NOT NULL
- auth_type — int — NOT NULL
- mb_login — datetime
- mb_datetime — datetime
- mb_leave_date — varchar(8)
- mb_intercept_date — varchar(8)
cnp_menu
- rt_id — int — Primary key — NOT NULL — 고유번호
- idx — varchar(20) — NOT NULL — 페이지 매칭고유값
- gr_id — tinyint(1) — NOT NULL — 그룹아이디
- rt_name — varchar(30) — NOT NULL — 메뉴명
- rt_use — tinyint(1) — NOT NULL — 메뉴사용
- rt_order — int — NOT NULL — 메뉴순서
- rt_url — varchar(100) — NOT NULL — 메뉴 경로
- rt_level — tinyint(1) — NOT NULL
- rt_target — tinyint(1) — NOT NULL — 1: 새창
cnp_ship
- sh_id — int — Primary key — NOT NULL — 고유번호
- sh_name — varchar(50) — NOT NULL — 선명
- pm_id — varchar(30) — NOT NULL — 프로젝트매니저아이디
- pm_name — varchar(50) — NOT NULL
- sh_owner — varchar(50) — NOT NULL — 선주사명
- sh_doc — int — NOT NULL — doc 고유번호 : 0 미지정
- sh_indate — datetime — NOT NULL — 입항시간
- sh_outdate — datetime — NOT NULL — 출항시간
- sh_point — varchar(2) — NOT NULL — 선수 e,w,s,n,
- sh_datetime — datetime — NOT NULL
cnp_uniqid
- uq_id — bigint — Primary key — NOT NULL
- uq_ip — varchar(255) — NOT NULL
cnp_visit
- cv_id — int — Primary key — NOT NULL — 고유번호
- mb_id — varchar(30) — NOT NULL — 등록자 아이디
- pm_id — varchar(30) — NOT NULL — 프로젝트담당자명
- sh_id — int — NOT NULL — 선명
- cv_type — varchar(50) — NOT NULL — 방문자구분
- cv_type2 — varchar(20) — NOT NULL — 방문자 구분 상세
- cv_subject — varchar(255) — NOT NULL — 방문목적
- is_certi — tinyint(1) — NOT NULL — 승인 정보 : 0 승인요청 , 1: 승인, 2: 승인완료 3:미승인
- certi_date — datetime
- cv_date — datetime — NOT NULL — 등록일
- cv_update — datetime — NOT NULL — 최종변경일
- cv_content — text — NOT NULL
- certi_hp — varchar(20) — NOT NULL
cnp_visitor
- vi_id — int — Primary key — NOT NULL
- cv_id — int — Primary key — NOT NULL — 방문정보 고유아이디
- pm_id — varchar(50) — NOT NULL
- sh_id — int — NOT NULL
- cc_id — int — NOT NULL
- vi_sdate — date
- vi_stime — varchar(2) — NOT NULL
- vi_sdatetime — int — NOT NULL
- vi_edate — date
- vi_etime — varchar(2) — NOT NULL
- vi_edatetime — int — NOT NULL
- vi_name — varchar(50) — NOT NULL — 방문자명
- vi_position — varchar(255) — NOT NULL — 직책
- vi_birth — varchar(10) — NOT NULL — 생년월일
- vi_birth2 — tinyint — NOT NULL
- vi_hp — varchar(20) — NOT NULL
- vi_blood — varchar(10) — NOT NULL — 혈액형
- vi_height — varchar(10) — NOT NULL — 키
- vi_car — varchar(50) — NOT NULL — 차량번호
- vi_car_number — varchar(50) — NOT NULL
- vi_input — text — NOT NULL — 반입물품
- vi_eye — varchar(255) — NOT NULL — 홍채
- vi_barcode — varchar(255) — NOT NULL — 바코드
- vi_certi — int — NOT NULL — 0: 미인증 , 1 인증 2: 미인증
- vi_state — int — NOT NULL — 0출 , 1 : 입
- vi_content — text — NOT NULL
- vi_datetime — datetime
cnp_write_notice
- wr_id — int — Primary key — NOT NULL
- wr_subject — varchar(255) — NOT NULL
- wr_content — text — NOT NULL
- wr_hit — int — NOT NULL
- wr_datetime — datetime
- wr_file — int — NOT NULL