KBbanner

Tables (18)

image_details (이미지상세)

  • Key — Primary key — NOT NULL

image_option (이미지리스트박스옵션)

  • img_option_id (Key) — Primary key — NOT NULL
  • img_option_category (옵션카테고리)
  • img_option_content (옵션내용)
  • img_option_del_yn (옵션삭제유무)

image_option (이미지옵션관리자)

  • img_option_id (옵션id) — int — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • img_option_category (옵션카테고리) — varchar
  • img_option_content (옵션내용) — varchar
  • img_option_del_yn (옵션삭제유무) — varchar

image_result (이미지생성결과)

  • img_id (이미지id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → users.user_id — NOT NULL
  • img_location (저장경로) — varchar
  • img_del_yn (이미지삭제유무) — varchar

image_results (이미지생성결과저장)

  • img_id (옵션id) — int — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • img_size (이미지사이즈) — varchar
  • img_style (이미지스타일) — varchar
  • img_color (이미지색상)
  • img_mood (이미지분위기)
  • img_background (이미지배경)
  • img_detail (이미지디테일수준)
  • img_prompt (이미지프롬프트)
  • created_at (Field)
  • updated_at (Field2)

image_selection (이미지옵션선택정보)

  • Key — Primary key — NOT NULL
  • img_option_id (Key2) — Foreign key → image_option.img_option_id — NOT NULL
  • img_id (이미지id) — int — Foreign key → image_result.img_id — NOT NULL
  • user_id (유저id) — int — Foreign key → image_result.user_id — NOT NULL
  • img_selection_del_yn (선택삭제유무)

product_leaflet_db (상품요약디비?(공통))

  • leaflet_id (상품id) — int — Primary key — NOT NULL
  • tenant_id (테넌트키) — Foreign key → users.user_id — NOT NULL
  • docs_id (문서id) — varchar
  • query (쿼리) — varchar
  • answer (엔써) — varchar
  • cmetadata (씨메타) — varchar

record (Untitled3)

  • record_id (기록id) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • division (이미지,문구)
  • api (사용api)
  • token (사용token)
  • prompt (프롬프트)
  • result (결과)

sentence_details (문구상세)

  • sent_dt_id (Key) — Primary key — NOT NULL
  • sent_id (옵션id) — int — Foreign key → sentence_results.sent_id — NOT NULL
  • sent_dt_rcmd (rcmd)
  • sent_dt_content (Field)
  • sent_dt_like (Field2)
  • created_at (Field3)
  • updated_at (Field4)

sentence_option (문구리스트박스옵션)

  • sent_option_id (옵션id) — int — Primary key — NOT NULL
  • sent_option_category (옵션카테고리) — varchar
  • sent_option_content (옵션내용) — varchar
  • sent_option_del_yn (옵션삭제유무) — varchar

sentence_option (문구옵션관리자)

  • sent_option_id (옵션id) — int — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • sent_opt_age_group (옵션카테고리) — varchar
  • sent_opt_gender (옵션내용) — varchar
  • sent_opt_imcome (옵션삭제유무) — varchar
  • sent_opt_tendency (Field)
  • sent_opt_occupation (Field2)
  • sent_opt_marry (Field3)
  • sent_opt_interst1 (Field4)
  • sent_opt_interest2 (Field5)
  • sent_opt_const1 (Field6)
  • sent_opt_const2 (Field7)
  • sent_opt_const3 (Field8)
  • sent_opt_const4 (Field9)
  • sent_opt_sysprom (Field10)
  • created_At (Field11)
  • updated_at (Field12)

sentence_result (문구생성결과)

  • sent_id (옵션id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → users.user_id — NOT NULL
  • sent_content (생성문장) — varchar
  • sent_del_yn (생성문작삭제유무) — varchar

sentence_results (문구생성결과저장)

  • sent_id (옵션id) — int — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • sent_age_group (연령대) — varchar
  • sent_gender (성별) — varchar
  • sent_income (소득수준)
  • sent_tendency (성향)
  • sent_occupation (직업)
  • sent_marry (결혼여부)
  • sent_interest1 (관심사1)
  • sent_interest2 (관심사2)
  • sent_prompt (프롬프트)
  • sent_content (생성문구)
  • created_at (Field)
  • updated_at (Field2)

sentenct_selection (옵션선택정보)

  • selection_id (선택id) — int — Primary key — NOT NULL
  • sent_option_id (옵션id) — int — Foreign key → sentence_option.sent_option_id — NOT NULL
  • sent_id (옵션id2) — int — Foreign key → sentence_result.sent_id — NOT NULL
  • user_id (유저id) — int — Foreign key → sentence_result.user_id — NOT NULL
  • sent_selection_del_yn (선택삭제유무) — varchar

template_option (템플릿옵션관리)

  • tmplt_id (템플릿id) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • tmplt_name (템플릿명)
  • tmplt_thumbnail (템플릿썸네일)
  • tmplt_back_width (배경가로)
  • tmplt_back_height (배경세로)
  • tmplt_back_color (배경색깔)
  • tmplt_logo_yn (로고생성유무)
  • tmplt_logo_width (로고가로)
  • tmplt_logo_height (로고세로)
  • tmplt_logo_x (로고x좌표)
  • tmplt_logo_y (로고y좌표)
  • tmplt_logo_location (로고이미지경로)
  • tmplt_text1_yn (텍스트1유무)
  • tmplt_text1_x (텍스트1x좌표)
  • tmplt_text1_y (텍스트1y좌표)
  • tmplt_text1_px (텍스트1픽셀)
  • tmplt_text1_color (텍스트1글자색)
  • tmplt_text1_font (텍스트1폰트)
  • tmplt_text1_style (텍스트1스타일)
  • tmplt_text1_sent (텍스트1문구)
  • tmplt_text2_yn (텍스트2유무)
  • tmplt_text2_x (텍스트2x좌표)
  • tmplt_text2_y (텍스트2y좌표)
  • tmplt_text2_px (텍스트2픽셀)
  • tmplt_text2_color (텍스트2글자색)
  • tmplt_text2_font (텍스트2폰트)
  • tmplt_text2_style (텍스트2스타일)
  • tmplt_text2_sent (텍스트2문구)
  • tmplt_text3_yn (텍스트3유무)
  • tmplt_text3_x (텍스트3x좌표)
  • tmplt_text3_y (텍스트3y좌표)
  • tmplt_text3_px (텍스트3픽셀)
  • tmplt_text3_color (텍스트3글자색)
  • tmplt_text3_font (텍스트3폰트)
  • tmplt_text3_style (텍스트3스타일)
  • tmplt_text3_sent (텍스트3문구)
  • tmplt_img1_yn (이미지1유무)
  • tmplt_img1_width (이미지1가로)
  • tmplt_img1_height (이미지1세로)
  • tmplt_img1_x (이미지1x좌표)
  • tmplt_img1_y (이미지1y좌표)
  • tmplt_img1_location (이미지1경로)
  • tmplt_img2_yn (이미지2유무)
  • tmplt_img2_width (이미지2가로)
  • tmplt_img2_height (이미지2세로)
  • tmplt_img2_x (이미지2x좌표)
  • tmplt_img2_y (이미지2y좌표)
  • tmplt_img2_location (이미지2경로)
  • tmplt_img3_yn (이미지3유무)
  • tmplt_img3_width (이미지3가로)
  • tmplt_img3_height (이미지3세로)
  • tmplt_img3_x (이미지3x좌표)
  • tmplt_img3_y (이미지3y좌표)
  • tmplt_img3_location (이미지3경로)
  • tmplt_del_yn (텍플릿삭제)

template_result (템플릿사용자결과저장)

  • tmplt_rslt_id (템플릿결과id) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → users.user_id — NOT NULL
  • tmplt_id (템플릿id2) — Foreign key → template_option.tmplt_id — NOT NULL
  • tmplt_rslt_name (템플릿명)
  • tmplt_rslt_thumbnail (템플릿썸네일)
  • tmplt_rslt_back_width (배경가로)
  • tmplt_rslt_back_height (배경세로)
  • tmplt_rslt_back_color (배경색깔)
  • tmplt_rslt_logo_yn (로고생성유무)
  • tmplt_rslt_logo_width (로고가로)
  • tmplt_rslt_logo_height (로고세로)
  • tmplt_rslt_logo_x (로고x좌표)
  • tmplt_rslt_logo_y (로고y좌표)
  • tmplt_rslt_logo_location (로고이미지경로)
  • tmplt_rslt_text1_yn (텍스트1유무)
  • tmplt_rslt_text1_x (텍스트1x좌표)
  • tmplt_rslt_text1_y (텍스트1y좌표)
  • tmplt_rslt_text1_px (텍스트1픽셀)
  • tmplt_rslt_text1_color (텍스트1글자색)
  • tmplt_rslt_text1_font (텍스트1폰트)
  • tmplt_rslt_text1_style (텍스트1스타일)
  • tmplt_rslt_text1_sent (텍스트1문구)
  • tmplt_rslt_text2_yn (텍스트2유무)
  • tmplt_rslt_text2_x (텍스트2x좌표)
  • tmplt_rslt_text2_y (텍스트2y좌표)
  • tmplt_rslt_text2_px (텍스트2픽셀)
  • tmplt_rslt_text2_color (텍스트2글자색)
  • tmplt_rslt_text2_font (텍스트2폰트)
  • tmplt_rslt_text2_style (텍스트2스타일)
  • tmplt_rslt_text2_sent (텍스트2문구)
  • tmplt_rslt_text3_yn (텍스트3유무)
  • tmplt_rslt_text3_x (텍스트3x좌표)
  • tmplt_rslt_text3_y (텍스트3y좌표)
  • tmplt_rslt_text3_px (텍스트3픽셀)
  • tmplt_rslt_text3_color (텍스트3글자색)
  • tmplt_rslt_text3_font (텍스트3폰트)
  • tmplt_rslt_text3_style (텍스트3스타일)
  • tmplt_rslt_text3_sent (텍스트3문구)
  • tmplt_rslt_img1_yn (이미지1유무)
  • tmplt_rslt_img1_width (이미지1가로)
  • tmplt_rslt_img1_height (이미지1세로)
  • tmplt_rslt_img1_x (이미지1x좌표)
  • tmplt_rslt_img1_y (이미지1y좌표)
  • tmplt_rslt_img1_location (이미지1경로)
  • tmplt_rslt_img2_yn (이미지2유무)
  • tmplt_rslt_img2_width (이미지2가로)
  • tmplt_rslt_img2_height (이미지2세로)
  • tmplt_rslt_img2_x (이미지2x좌표)
  • tmplt_rslt_img2_y (이미지2y좌표)
  • tmplt_rslt_img2_location (이미지2경로)
  • tmplt_rslt_img3_yn (이미지3유무)
  • tmplt_rslt_img3_width (이미지3가로)
  • tmplt_rslt_img3_height (이미지3세로)
  • tmplt_rslt_img3_x (이미지3x좌표)
  • tmplt_rslt_img3_ y (이미지3y좌표)
  • tmplt_rslt_img3_location (이미지3경로)
  • tmplt_rslt_del_yn (텍플릿삭제)

users (Untitled2)

  • user_id (Key) — Primary key — NOT NULL

users (Untitled)

  • user_id (유저id) — int — Primary key — NOT NULL
  • Field