nakkci
Tables (12)
tb_account (관리자)
- i_seq (관리자SEQ) — BIGINT — Primary key — NOT NULL
- s_id (관리자ID) — VARCHAR
- s_pw (관리자PW) — VARCHAR
- s_nm (관리자이름) — VARCHAR
- s_nick (닉네임) — VARCHAR
- c_type (관리자타입 : S:슈퍼관리자, N:관리자) — CHAR
- s_phone (전화번호) — VARCHAR
- c_approval_yn (승인여부) — CHAR
- c_use_yn (사용여부) — CHAR
- c_del_yn (삭제여부) — CHAR
tb_alarm (알람)
- i_seq (알람SEQ) — BIGINT — Primary key — NOT NULL
- s_title (알람제목) — VARCHAR
- c_recommend_yn (추천유무) — CHAR
- dt_create_time (알람등록시간) — DATETIME
tb_common_code (공통코드)
- s_master_code (공통마스터CD) — VARCHAR — Primary key — NOT NULL
- s_commom_cd (공통코드) — VARCHAR — Primary key — NOT NULL
- s_master_nm (공콩마스터이름) — VARCHAR
- s_common_nm (공통코드이름) — VARCHAR
- s_common_desc (공통코드설명) — VARCHAR
- s_value01 (값01) — VARCHAR
- s_value02 (값02) — VARCHAR
- i_disp_no (표시순서) — TINYINT
- c_system_yn (시스템등록여부) — CHAR
- c_use_yn (사용여부) — CHAR
- c_del_yn (삭제여부) — CHAR
- s_create_id (등록자ID) — VARCHAR
- dt_create_time (등록일시) — DATETIME
- s_update_id (갱신자ID) — VARCHAR
- dt_update_time (갱신일시)
tb_event (이벤트)
- i_seq (이벤트SEQ) — BIGINT — Primary key — NOT NULL
- s_cd (이벤트코드) — VARCHAR
- s_title (이벤트제목) — VARCHAR
- s_main_img_nm (전체이미지명) — VARCHAR
- s_sub_img_nm (세부이미지명) — VARCHAR
- s_main_img_path (전체이미지경로) — VARCHAR
- s_sub_img_path (세부이미지경로) — VARCHAR
- s_main_img_size (전체이미지크기) — VARCHAR
- s_sub_img_size (세부이미지크기) — VARCHAR
- c_use_yn (사용여부) — CHAR
- c_del_yn (삭제여부) — CHAR
- c_disp_yn (전시여부) — CHAR
- dt_event_term (이벤트기간) — DATETIME
tb_notice (공지사항)
- i_seq (공지사항SEQ) — BIGINT — Primary key — NOT NULL
- s_title (공지사항제목) — VARCHAR
- t_content (내용) — TEXT
- s_file_nm (첨부파일명) — VARCHAR
- s_file_path (첨부파일경로) — VARCHAR
- s_file_size (첨부파일크기) — VARCHAR
- c_use_yn (사용여부) — CHAR
- c_del_yn (삭제여부) — CHAR
- s_create_id (등록자ID) — VARCHAR
- dt_create_time (등록일시) — DATETIME
- s_update_id (갱신자ID) — VARCHAR
- dt_update_time (갱신일지) — DATETIME
tb_post (포스트(후기))
- i_seq (포스트SEQ) — BIGINT — Primary key — NOT NULL
- s_img_nm (이미지명) — VARCHAR
- s_img_path (이미지경로) — VARCHAR
- s_img_size (이미지크기) — VARCHAR
- t_content (내용) — TEXT
- s_nm (이름) — VARCHAR
- s_pw (비밀번호) — VARCHAR
- s_store_nm (낚시터이름) — VARCHAR
- c_del_yn (삭제여부) — CHAR
- dt_create_time (등록일시) — DATETIME
- dt_update_time (갱신일시) — DATETIME
tb_reservation (사용자예약)
- i_seq (예약SEQ) — BIGINT — Primary key — NOT NULL
- s_store_nm (낚시터이름) — VARCHAR
- s_user_nm (예약자명) — VARCHAR
- s_pw (비밀번호) — VARCHAR
- s_phone (전화번호) — VARCHAR
- i_person (인원) — INT
- dt_reserve_day (예약일) — DATE
- dt_reserve_time (예약시간) — TIME
tb_sales_purchase (매출/매입관리)
- i_seq (매출매입SEQ) — BIGINT — Primary key — NOT NULL
- i_total_sales (월매출합계) — INT
- i_total_purch (월매입합계) — INT
- i_sales_day (해당일매출액) — INT
- i_purch_day (해당일매입액) — INT
- s_account (거래처) — VARCHAR
- s_product (상품) — VARCHAR
- i_price (상품가격) — INT
- dt_deal (거래일자) — DATETIME
tb_store (매장등록)
- i_seq (사용자SEQ) — BIGINT — Primary key — NOT NULL
- s_cd (지점등록번호) — VARCHAR
- s_id (아이디) — VARCHAR
- s_pw (비밀번호) — VARCHAR
- s_nm (이름) — VARCHAR
- dt_last (마지막로그인일시) — DATETIME
- dt_create_time (등록일시) — DATETIME
tb_store_info (낚시터정보)
- i_seq (낚시터SEQ) — BIGINT — Primary key — NOT NULL
- c_place (지역 : A:수도권, B:충청도, C:전라도, D:경상도, E:강원도, F:제주도) — CHAR
- c_theme (테마 : A:가족, B:아빠와아들, C:연인, D:친구, E:회사, F:단체) — CHAR
- s_store_nm (낚시터이름) — VARCHAR
- s_fish (대표어종) — VARCHAR
- s_addr (주소) — VARCHAR
- s_hashtag (해시태그) — VARCHAR
- s_price (이용금액) — DECIMAL(6, 5)
- c_type (낚시터구분 : D:직영, N:일반) — CHAR
- s_distance (거리) — VARCHAR
- s_img_nm (이미지명) — TEXT
- s_img_path (이미지경로) — VARCHAR
- s_img_size (이미지크기) — VARCHAR
- s_notice (공지사항) — VARCHAR
- t_content (내용(사장님이전하고싶은말)) — TEXT
tb_store_login (매장로그인)
- i_seq (사용자로그인SEQ) — BIGINT — Primary key — NOT NULL
- s_id (아이디) — VARCHAR
- s_pw (비밀번호) — VARCHAR
- dt_create_time (등록일시) — DATETIME
tb_terms (약관)
- i_seq (약관SEQ) — BIGINT — Primary key — NOT NULL
- c_type (약관유형 : A:이용약관, B:개인정보처리방침, C:개인정보제3자제공동의) — CHAR
- s_nm (약관명) — VARCHAR
- s_desc (약관설명) — VARCHAR
- t_content (약관내용) — TEXT
- c_use_yn (사용여부) — CHAR
- c_del_yn (삭제여부) — CHAR
- s_create_id (등록자ID) — VARCHAR
- dt_create_time (등록일시) — DATETIME
- s_update_id (갱신자ID) — VARCHAR
- dt_update_time (갱신일시) — DATETIME