TEST_TMP

Tables (27)

SPRING_SESSION

  • PRIMARY_ID — char(36) — Primary key — NOT NULL
  • SESSION_ID — char(36) — NOT NULL
  • CREATION_TIME — bigint(20) — NOT NULL
  • LAST_ACCESS_TIME — bigint(20) — NOT NULL
  • MAX_INACTIVE_INTERVAL — int(11) — NOT NULL
  • EXPIRY_TIME — bigint(20) — NOT NULL
  • PRINCIPAL_NAME — varchar(100)

SPRING_SESSION_ATTRIBUTES

  • ATTRIBUTE_NAME — varchar(200) — Primary key — NOT NULL
  • SESSION_PRIMARY_ID — char(36) — Foreign key → SPRING_SESSION.PRIMARY_ID — NOT NULL
  • ATTRIBUTE_BYTES — blob — NOT NULL

TBL_SCHEDULE

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • create_limit — int(11) — NOT NULL
  • created_count — int(11) — NOT NULL
  • cron — varchar(255)
  • expire_at — datetime(6)
  • jmeter_xml — mediumblob
  • metadata — varchar(255)
  • name — varchar(255)
  • on_sample_error — varchar(255)
  • start_at — datetime(6)
  • user_email — varchar(255) — Foreign key → TB_USER.user_email

TBL_TASK

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • is_completed — bit(1) — NOT NULL
  • jmeter_xml — mediumblob
  • step_status — mediumtext
  • worker_node_count — int(11) — NOT NULL
  • schedule_id — int(11) — Foreign key → TBL_SCHEDULE.id

TBL_WORKER_POOL

  • id — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • ip — varchar(255)
  • jmeter_control_service_port — int(11) — NOT NULL
  • jmeter_worker_service_port — int(11) — NOT NULL
  • phase — varchar(255)

TBL_WORKER_TASK_STATE

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • status — int(11) — NOT NULL
  • task_id — int(11) — Foreign key → TBL_TASK.id
  • worker_pool_id — varchar(255) — Foreign key → TBL_WORKER_POOL.id

TB_AUTHORITY

  • authority_code — varchar(50) — Primary key — NOT NULL — 권한 코드
  • authority_name — varchar(100) — 권한 명
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_AUTHORITY_MENU

  • menu_no — int(5) — Foreign key → TB_MENU.menu_no — 메뉴 번호
  • authority_code — varchar(50) — Foreign key → TB_AUTHORITY.authority_code — 권한 코드
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_COMMON_CODE

  • code — varchar(50) — Primary key — NOT NULL — 코드
  • code_name — varchar(100) — 코드 명
  • parent_code — varchar(50) — 부모 코드
  • description — varchar(2000) — 설명
  • is_active — tinyint(1) — 사용 여부
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_COMMON_CODE_DETAIL

  • code_detail_code — varchar(50) — Primary key — NOT NULL — 상세 코드
  • code — varchar(50) — Foreign key → TB_COMMON_CODE.code — 코드
  • code_detail_name — varchar(100) — 코드 상세 명
  • description — varchar(2000) — 설명
  • order_no — int(5) — 순서
  • is_active — tinyint(1) — 사용 여부
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_CONTRACT

  • contract_no — int(11) — Primary key — NOT NULL — 계약 코드
  • organization_code — char(9) — Primary key — NOT NULL — 조직 코드
  • contract_start_date — char(8) — 계약 시작일
  • contract_end_date — char(9) — 계약 종료일
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_CUSTOMER

  • customer_uuid — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • address — varchar(255)
  • address_detail — varchar(255)
  • zip_code — varchar(255)
  • business_registration_number — varchar(255)
  • contract_end_date — date
  • contract_start_date — date
  • customer_name — varchar(255)
  • description — varchar(255)
  • nc_customer_account_id — varchar(255)
  • nc_customer_account_key — int(11)
  • representative_email — varchar(255)
  • representative_name — varchar(255)
  • representative_tel — varchar(255)

TB_DEPARTMENT

  • company_uuid — varchar(255) — Primary key — NOT NULL
  • department_code — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • department_name — varchar(255)
  • parent_department_code — varchar(255)

TB_MAIL_HISTORY

  • email_uuid — varchar(36) — Primary key — NOT NULL
  • email_token — varchar(2000) — 메일 토큰
  • email_to — varchar(100) — 메일 수신 주소
  • email_type_code — varchar(50) — 메일 구분 코드
  • subject — varchar(1000) — 메일 제목
  • content — varchar(2000) — 메일 내용
  • email_send_at — datetime — 메일 발송 일시
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_MENU

  • menu_no — int(5) — Primary key — NOT NULL — 메뉴 번호
  • menu_name — varchar(100) — 메뉴 명
  • menu_url — varchar(200) — 메뉴 URL
  • menu_icon — varchar(100) — 메뉴 아이콘
  • parent_menu_no — int(5) — 상위 메뉴 번호
  • description — varchar(2000) — 설명
  • order_no — int(5) — 순서
  • menu_type_code — varchar(50) — 메뉴 구분 코드
  • authority_code — char(4) — 권한 코드
  • is_active — tinyint(1) — 사용 여부
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_ORGANIZATION

  • organization_code — char(9) — Primary key — NOT NULL — 조직 코드
  • organization_name — varchar(100) — 조직 명
  • organization_type_code — varchar(50) — 조직 유형 코드
  • parent_organization_code — varchar(50) — 상위 조직 코드
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_ORGANIZATION_ACCOUNT

  • account_no — int(5) — Primary key — NOT NULL — 계정 번호
  • organization_code — char(9) — Foreign key → TB_ORGANIZATION.organization_code — NOT NULL — 조직 코드
  • account_name — varchar(100) — NOT NULL — 계정명
  • access_key — varchar(200) — NOT NULL — accesskey
  • secret_key — varchar(200) — NOT NULL — secretkey
  • platform_type — varchar(50) — 플랫폼타입
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일자
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_ORGANIZATION_DETAIL

  • organization_code — char(9) — NOT NULL — 조직 코드
  • business_registration_number — char(10) — 사업자등록번호
  • representative_name — varchar(100) — 대표자 명
  • representative_tel — varchar(11) — 대표 전화
  • representative_email — varchar(200) — 대표 이메일
  • zip_code — char(5) — 우편번호
  • address — varchar(200) — 도로명주소
  • address_detail — varchar(200) — 상세주소
  • description — varchar(2000) — 설명
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_ROLE

  • role_code — varchar(50) — Primary key — NOT NULL — 역할 코드
  • role_name — varchar(100) — 역할 명
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_ROLE_AUTHORITY

  • authority_code — varchar(50) — Primary key — NOT NULL — 권한 코드
  • role_code — varchar(50) — Primary key — NOT NULL — 메뉴 번호
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_USER

  • user_email — varchar(200) — Primary key — NOT NULL — 사용자 이메일
  • organization_code — char(9) — Primary key — NOT NULL
  • user_name — varchar(100) — 사용자 명
  • password — varchar(200) — 사용자 비밀번호
  • tel — varchar(11) — 사용자 전화번호
  • is_active — tinyint(1) — 사용 여부
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_USER_AUTHORITY

  • authority_code — varchar(255) — Primary key — NOT NULL
  • company_type_code — varchar(255) — Primary key — NOT NULL
  • company_uuid — varchar(255) — Primary key — NOT NULL
  • user_uuid — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • managed_customer_list — varchar(255)
  • user_email — varchar(200) — Foreign key → TB_USER.user_email — NOT NULL — 사용자 이메일
  • organization_code — char(9) — Foreign key → TB_USER.organization_code — NOT NULL

TB_USER_HISTORY

  • history_at — char(23) — Primary key — NOT NULL — 이력 일시
  • user_email — varchar(200) — Primary key — NOT NULL — 사용자 이메일
  • user_history_type_code — varchar(50) — 사용자 이력 유형 코드
  • user_update_content — varchar(2000)
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시
  • user_email (user_email2) — varchar(200) — Foreign key → TB_USER.user_email — NOT NULL — 사용자 이메일
  • organization_code — char(9) — Foreign key → TB_USER.organization_code — NOT NULL

TB_USER_LOGIN_HISTORY

  • history_at — char(23) — Primary key — NOT NULL — 이력 일시
  • user_email — varchar(200) — Primary key — NOT NULL — 사용자 이메일
  • token_uuid — varchar(36) — 토큰 UUID
  • accessed_at — datetime — 접속시간
  • ip_address — char(15) — IP
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_USER_LOG_HISTORY

  • log_no — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • created_by — varchar(255)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • updated_by — varchar(255)
  • accessed_at — datetime(6)
  • ip_address — varchar(255)
  • token_uuid — varchar(255)
  • user_uuid — varchar(255)

TB_USER_ROLE

  • role_code — varchar(50) — Primary key — NOT NULL — 역할 코드
  • user_email — varchar(200) — Primary key — NOT NULL — 사용자 이메일
  • created_by — varchar(36) — NOT NULL — 최초생성자
  • created_at — datetime — NOT NULL — 최초생성일시
  • updated_by — varchar(36) — 최종수정자
  • updated_at — datetime — 최종수정일시
  • deleted_at — datetime — 삭제일시

TB_USER_SIGNUP

  • email_uuid — varchar(36) — Primary key — NOT NULL
  • user_email — varchar(200) — NOT NULL
  • user_name — varchar(100) — NOT NULL
  • password — varchar(200) — NOT NULL
  • email_verified_at — datetime
  • is_approved — tinyint(1) — NOT NULL
  • approved_by — varchar(36)
  • approved_at — datetime
  • created_by — varchar(36) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_by — varchar(36)
  • updated_at — datetime
  • deleted_at — datetime