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