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