test
Tables (49)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_INSTANCE_ID — bigint — Foreign key → BATCH_JOB_INSTANCE.JOB_INSTANCE_ID — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
- JOB_CONFIGURATION_LOCATION — varchar(2500)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- TYPE_CD — varchar(6) — NOT NULL
- KEY_NAME — varchar(100) — NOT NULL
- STRING_VAL — varchar(250)
- DATE_VAL — datetime(6)
- LONG_VAL — bigint
- DOUBLE_VAL — double
- IDENTIFYING — char(1) — NOT NULL
BATCH_JOB_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_NAME — varchar(100) — NOT NULL
- JOB_KEY — varchar(32) — NOT NULL
BATCH_JOB_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint — NOT NULL
- STEP_NAME — varchar(100) — NOT NULL
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- START_TIME — datetime(6) — NOT NULL
- END_TIME — datetime(6)
- STATUS — varchar(10)
- COMMIT_COUNT — bigint
- READ_COUNT — bigint
- FILTER_COUNT — bigint
- WRITE_COUNT — bigint
- READ_SKIP_COUNT — bigint
- WRITE_SKIP_COUNT — bigint
- PROCESS_SKIP_COUNT — bigint
- ROLLBACK_COUNT — bigint
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — bigint — Foreign key → BATCH_STEP_EXECUTION.STEP_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_STEP_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
access_token
- access_token_no — int — Primary key — NOT NULL
- uuid — text — NOT NULL
- create_time — datetime — NOT NULL
- expire_time — datetime — NOT NULL
- admin_no — int — NOT NULL
account
- account_no — int — Primary key — NOT NULL
- account_num — text
- user_erp_code — text
- user_bussiness_regist — text
- user_bank_code — text
admin
- admin_no — int — Primary key — NOT NULL
- member_no — int
- admin_id — varchar(256)
- admin_pw — text
- admin_name — text
- admin_email — text
- admin_phone — text
- admin_authority — text
- create_date — date
- modify_date — date
alliance
- alliance_no — int — Primary key — NOT NULL
- alliance_title — varchar(255) — 제휴 제목
- alliance_url — varchar(255)
- alliance_image — varchar(255)
- alliance_origin_image — varchar(255) — 제휴 원본 이미지
- alliance_type — int — 1) sk제휴, 2) 기타
- alliance_status — int — 0) 비활성화, 1) 활성화
- create_date — datetime
- modify_date — datetime
area
- area_no — int — Primary key — NOT NULL
- area_title — varchar(255)
ask
- ask_no — int — Primary key — NOT NULL
- member_no — int — NOT NULL
- ask_type — int
- ask_title — varchar(255)
- ask_email — varchar(255)
- ask_content — text
- ask_phone — varchar(12)
- ask_file — text
- ask_origin_file — varchar(255)
- ask_answer — text
- ask_manager — int
- ask_answer_date — datetime
- create_date — datetime
- modify_date — datetime
authority
- authority_no — int — Primary key — NOT NULL
- authority_title — varchar(45)
- authority_description — text
banner
- banner_no — int — Primary key — NOT NULL
- banner_title — varchar(255)
- banner_intro — varchar(255)
- banner_url — varchar(255)
- banner_order — int
- banner_image — varchar(255)
- banner_origin_image — varchar(255) — 배너 원본 이미지
- banner_status — tinyint
- create_date — datetime
- modify_date — datetime
board
- board_no — int — Primary key — NOT NULL
- board_title — varchar(255)
- board_content — varchar(255)
- create_date — datetime
- modify_date — datetime
- board_count — int
- user_no — int — NOT NULL
cart
- cart_no — int — Primary key — NOT NULL
- option_no — int — NOT NULL
- member_no — int — NOT NULL
- order_count — int
- create_date — datetime
- modify_date — datetime
- product_no — int
category
- cat_no — int — Primary key — NOT NULL
- cat_title — varchar(255)
- cat_parent — int — 0)대분류 / 상속받는 카테고리 번호
- cat_depth — int — 1) 대분류 2) 소분류
- cat_image — varchar(255)
- cat_type — varchar(255)
ckimage
- ckimage_no — int — Primary key — NOT NULL
- ckimage_name — text
- ckimage_org_name — text
- ckimage_path — text
- ckimage_type — text
- ckimage_item_no — int
ckimage_temp
- ckimage_temp_no — int — Primary key — NOT NULL
- ckimage_name — text
- ckimage_org_name — text
- create_date — date
- uuid — text
- ckimage_path — text
cs
- cs_no — int — Primary key — NOT NULL
- cs_sub_cat_no — int
- user_no — int
- admin_no — int
- create_date — date
- modify_date — date
- complete_date — date
- cs_content — varchar(256)
- txn_no — int
- cs_status — int
- product_no — int
cs_main_cat
- cs_main_cat_no — int — Primary key — NOT NULL
- cs_main_cat_title — varchar(256)
cs_sub_cat
- cs_sub_cat_no — int — Primary key — NOT NULL
- cs_main_cat_no — int
- cs_sub_cat_title — varchar(45)
each
- each_no — int — Primary key — NOT NULL
- each_name — varchar(45)
- each_type — int
event
- event_no — int — Primary key — NOT NULL
- event_title — varchar(256)
- event_content — text
- start_date — date
- end_date — date
- create_date — date
- modify_date — date
- event_mgr — int
- event_thumb — text
- event_thumb_org — text
- event_status — int
event_target
- event_target_no — int — Primary key — NOT NULL
- event_no — int
- user_no — int
faq
- faq_no — int — Primary key — NOT NULL
- faq_title — varchar(255) — NOT NULL
- faq_content — text — NOT NULL
- faq_category — varchar(255)
- create_date — datetime
- modify_date — datetime
- faq_count — int
- user_no — int — Foreign key → user.user_no — NOT NULL
member
- member_no — int — Primary key — NOT NULL
- member_id — varchar(45)
- member_pwd — varchar(255)
- member_role — varchar(45)
- create_date — datetime
- modify_date — datetime
myshop_offer
- myshop_id — int — Primary key — NOT NULL
- member_no — int — Foreign key → user.user_no
- myshop_company — varchar(255)
- myshop_ceo — varchar(255)
- myshop_phone_rep — varchar(12)
- myshop_phone — varchar(12)
- myshop_phone_etc — varchar(12)
- myshop_zipcode — varchar(20)
- myshop_address — varchar(255)
- myshop_address_detail — varchar(255)
- myshop_email — varchar(255)
- myshop_detail — text
- myshop_file — varchar(255)
- myshop_origin_file — varchar(255)
- create_date — datetime
- modify_date — datetime
notice
- notice_no — int — Primary key — NOT NULL
- admin_no — int
- notice_title — varchar(255)
- notice_content — text
- create_date — datetime
- modify_date — datetime
options
- option_no — int — Primary key — NOT NULL
- product_no — int — NOT NULL
- option_name — varchar(255)
- option_price — int
- option_inventory — int
- create_date — datetime
popup
- popup_no — int — Primary key — NOT NULL
- popup_file — varchar(255)
- create_date — datetime
- modify_date — datetime
product
- product_no — int — Primary key — NOT NULL
- product_vendor — int — NOT NULL
- cat_no — int — NOT NULL
- product_title — varchar(255)
- product_type — varchar(45)
- product_featured — int — 1) 승인대기 2) 판매중 3) 품절 4 )숨김 5) 반려
- product_company — varchar(255)
- product_standard — varchar(255)
- product_min — varchar(255)
- product_max — int
- product_price — int
- product_list_price — int
- product_count — int
- product_in_count — int
- product_basic — text
- product_detail — text
- start_date — date
- end_date — date
- product_md — char(1)
- product_each — int
- create_date — datetime
- modify_date — datetime
- product_code — varchar(50)
- product_open_check — char(1)
- product_event — int
product_area
- product_area_no — int — Primary key — NOT NULL
- product_no — int — Foreign key → product.product_no
- area_no — int
product_erp
- product_erp_no — int — Primary key — NOT NULL
- product_code — varchar(20)
- create_date — date
- result_code — varchar(3)
- result_desc — varchar(256)
product_file
- product_file_no — int — Primary key — NOT NULL
- product_file_name — varchar(255)
- product_origin_file_name — varchar(255)
- product_no — int — Foreign key → product.product_no
- file_type — int
product_log
- product_log_no — int — Primary key — NOT NULL
- product_no — int
- admin_no — int
- product_log_reason — text
- product_log_before_price — int
- product_log_after_price — int
- create_date — datetime
product_offer
- offer_id — int — Primary key — NOT NULL
- offer_title — varchar(255)
- offer_detail — varchar(255)
- offer_email — varchar(50)
- offer_phone — varchar(20)
- create_date — datetime
- modify_date — datetime
- member_no — int
- offer_file — varchar(255)
- offer_origin_file_name — varchar(255)
- offer_parent — int
- offer_status — int — 0) 확인 전 1) 확인
product_type
- product_type_no — int — Primary key — NOT NULL
- type_title — varchar(45)
- type_id — varchar(45)
qna
- qna_no — int — Primary key — NOT NULL
- member_no — int — NOT NULL
- product_no — int
- qna_title — varchar(255)
- qna_content — text
- qna_date — datetime
- qna_type — int
- create_date — datetime
- modify_date — datetime
- qna_state — int
- qna_answer — text
- qna_manager — int
- qna_answer_date — datetime
- qna_phone — varchar(50)
- qna_email — varchar(255)
shipping_address
- shipping_adr_no — int — Primary key — NOT NULL
- member_no — int
- shipping_adr_title — varchar(50)
- shipping_adr_email — varchar(45)
- shipping_adr_username — varchar(20)
- shipping_adr_phone — varchar(20)
- shipping_adr_tel — varchar(20)
- shipping_adr_zipcode — varchar(20)
- shipping_adr_address — varchar(255)
- shipping_adr_address_detail — varchar(255)
- shipping_adr_type — char(1) — 1) main 2) sub
- create_date — datetime
- modify_date — datetime
transaction
- txn_no — int — Primary key — NOT NULL
- member_no — int — NOT NULL
- txn_code — varchar(50)
- txn_status — int
- txn_total_price — int
- txn_price — int
- txn_sale_price — int
- txn_shipping — int
- txn_date — datetime
- receiver_name — varchar(30)
- receiver_phone — varchar(20)
- receiver_tel — varchar(45)
- receiver_zipcode — varchar(10)
- receiver_address — varchar(255)
- receiver_detail_address — varchar(255)
- receiver_email — varchar(45)
- txn_memo — varchar(255)
- create_date — datetime
- modify_date — datetime
- bills_bm — text
- bills_email — text
- bills_phone — text
- user_bns_number — text
transaction_product
- txn_prd_no — int — Primary key — NOT NULL
- txn_no — int — NOT NULL
- product_no — int — NOT NULL
- txn_prd_count — int
- txn_prd_price — int
- txn_prd_status — int — 0) 미입금 1) 결제완료 2) 취소완료 3) 환불완료
- create_date — datetime
user
- user_no — int — Primary key — NOT NULL
- member_no — int
- user_id — varchar(255)
- user_password — varchar(255)
- user_name — varchar(200)
- user_zipcode — char(7)
- user_address — varchar(400)
- user_detail_address — varchar(400)
- user_area_code — int
- user_phone — varchar(50)
- user_tel — varchar(50)
- user_email — varchar(200)
- user_email_check — char(1)
- user_sms_check — char(1)
- user_birth_day — date
- user_fax — varchar(255)
- user_bussiness_regist — varchar(45)
- user_bussiness_type — varchar(255)
- user_gas_name — varchar(45)
- user_gas_type — int
- user_role — varchar(45)
- rc_code — varchar(45)
- manager_bill — varchar(255)
- email_bill — varchar(255)
- tel_bill — varchar(255)
- account_check — int — 0) false 1) true
- create_date — datetime
- modify_date — datetime
- user_authority — text
user_application
- application_no — int — Primary key — NOT NULL
- application_business_no — varchar(30)
- application_business_name — varchar(45)
- application_corporate_no — varchar(35)
- application_business_status — varchar(20)
- application_user_name — varchar(20)
- application_business_type — varchar(20)
- application_email — varchar(30)
- application_phone — varchar(20)
- application_tel — varchar(20)
- application_zipcode — varchar(20)
- application_address — varchar(100)
- application_address_detail — varchar(255)
- application_origin_file_name — varchar(100)
- application_file_name — varchar(100)
- application_status — char(1) — 1 ) 신청(승인대기) 2) 완료(승인완료)
- create_date — datetime
- modify_date — datetime
vaccount_origin
- vo_pay_no — int — Primary key — NOT NULL
- vo_account_num — text
- vo_erp_code — text
- vo_bns_num — text
- vo_pay_ammount — text
- vo_pay_date — text
- vo_pay_time — text
vendor
- vendor_no — int — Primary key — NOT NULL
- member_no — int
- vendor_code — varchar(45)
- vendor_name — varchar(45)
- vendor_sort — varchar(45)
- vendor_bns_num — varchar(45)
- vendor_ceo_name — varchar(45)
- vendor_reg_num — varchar(45)
- vendor_bns_clsfp — varchar(45)
- vendor_bns_type — varchar(45)
- vendor_city — varchar(255)
- vendor_street — varchar(255)
- vendor_post_num — varchar(45)
- vendor_email — varchar(45)
- vendor_phone — varchar(45)
- vendor_fax — varchar(45)
- create_date — datetime
- modify_date — datetime