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