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