팬텍_전자계약_MSSQL_백업_20260720
테이블 (35)
TB_APPROVAL
- APPROVAL_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- DRAFTER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- STATUS_CD — VARCHAR(20) — NOT NULL
- DRAFT_OPINION — NVARCHAR(MAX)
- REJECT_REASON — NVARCHAR(500)
- DRAFTED_AT — DATETIME2(0)
- COMPLETED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_APPROVAL_LINE
- LINE_ID — BIGINT — 기본 키 — NOT NULL
- APPROVAL_ID — BIGINT — 외래 키 → TB_APPROVAL.APPROVAL_ID — NOT NULL
- STEP_NO — INT — NOT NULL
- APPROVER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- LINE_ROLE — VARCHAR(20)
- LINE_STATUS — VARCHAR(20) — NOT NULL
- ACTION_CD — VARCHAR(20)
- OPINION — NVARCHAR(500)
- PROCESSED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_ATTACHMENT
- ATTACHMENT_ID — BIGINT — 기본 키 — NOT NULL
- BIZ_TYPE — VARCHAR(30) — NOT NULL
- BIZ_ID — BIGINT
- ORIGIN_NAME — NVARCHAR(260) — NOT NULL
- STORED_NAME — NVARCHAR(100) — NOT NULL
- FILE_PATH — NVARCHAR(500) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- EXT — VARCHAR(10)
- MIME_TYPE — VARCHAR(100)
- FILE_HASH — CHAR(64)
- DOWNLOAD_CNT — INT — NOT NULL
- SORT_NO — INT
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_AUDIT_LOG
- LOG_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT
- LOGIN_ID — VARCHAR(8)
- MENU_CD — VARCHAR(30)
- ACTION — VARCHAR(20) — NOT NULL
- TARGET_TABLE — VARCHAR(50)
- TARGET_ID — VARCHAR(50)
- BEFORE_VAL — NVARCHAR(MAX)
- AFTER_VAL — NVARCHAR(MAX)
- IP — VARCHAR(45)
- USER_AGENT — NVARCHAR(500)
- RESULT_CD — VARCHAR(10) — NOT NULL
- LOG_AT — DATETIME2(0) — NOT NULL
TB_AUTH_LOG
- AUTH_LOG_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- TARGET_ID — BIGINT — 외래 키 → TB_SIGN_REQUEST_TARGET.TARGET_ID
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID
- AUTH_PURPOSE — VARCHAR(20) — NOT NULL
- AUTH_METHOD — VARCHAR(20) — NOT NULL
- AUTH_STATUS — VARCHAR(20) — NOT NULL
- REQ_TX_ID — VARCHAR(100)
- RES_CI — VARBINARY(256)
- RES_DI — VARBINARY(256)
- AUTH_NAME — NVARCHAR(50)
- AUTH_BIRTH — CHAR(8)
- AUTH_MOBILE — VARCHAR(20)
- TELECOM_CD — VARCHAR(10)
- RESULT_CODE — VARCHAR(20)
- RESULT_MSG — NVARCHAR(200)
- CLIENT_IP — VARCHAR(45)
- USER_AGENT — NVARCHAR(500)
- REQUESTED_AT — DATETIME2(0) — NOT NULL
- COMPLETED_AT — DATETIME2(0)
- PII_PURGED_AT — DATETIME2(0)
TB_BID_AWARD
- BID_AWARD_ID — BIGINT — 기본 키 — NOT NULL
- BID_NO — VARCHAR(30) — NOT NULL
- WINNER_BIZ_NO — VARCHAR(12) — NOT NULL
- WINNER_NAME — NVARCHAR(100)
- BID_AMOUNT — DECIMAL(18,0)
- ITEM_DESC — NVARCHAR(400)
- SYNC_AT — DATETIME2(0) — NOT NULL
- MAPPED_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_BID_CONTRACT_MAP
- MAP_ID — BIGINT — 기본 키 — NOT NULL
- BID_AWARD_ID — BIGINT — 외래 키 → TB_BID_AWARD.BID_AWARD_ID — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- REPLY_STATUS — VARCHAR(20) — NOT NULL
- REPLY_FAIL_CNT — INT — NOT NULL
- REPLIED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CODE
- CODE — VARCHAR(30) — 기본 키 — NOT NULL
- GROUP_CD — VARCHAR(30) — 외래 키 → TB_CODE_GROUP.GROUP_CD — NOT NULL
- CODE_NAME — NVARCHAR(100) — NOT NULL
- DESCRIPTION — NVARCHAR(500)
- SORT_NO — INT — NOT NULL
- ATTR1 — NVARCHAR(100)
- ATTR2 — NVARCHAR(100)
- REF_DOC — NVARCHAR(200)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CODE_GROUP
- GROUP_CD — VARCHAR(30) — 기본 키 — NOT NULL
- GROUP_NAME — NVARCHAR(100) — NOT NULL
- DESCRIPTION — NVARCHAR(500)
- SYSTEM_YN — CHAR(1) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT
- CONTRACT_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_NO — VARCHAR(30)
- CONTRACT_NAME — NVARCHAR(200) — NOT NULL
- PARTNER_ID — BIGINT — 외래 키 → TB_PARTNER.PARTNER_ID — NOT NULL
- FORM_ID — BIGINT — 외래 키 → TB_FORM_TEMPLATE.FORM_ID
- CONTRACT_TYPE — VARCHAR(20)
- FORM_VERSION — VARCHAR(20)
- AMOUNT — DECIMAL(18,0)
- CURRENCY_CD — VARCHAR(20) — NOT NULL
- SUPPLY_AMOUNT — DECIMAL(18,0)
- TAX_TYPE_CD — VARCHAR(20)
- VAT_AMOUNT — DECIMAL(18,0)
- PAYMENT_METHOD_CD — VARCHAR(20)
- PAYMENT_TIMING_CD — VARCHAR(20)
- PAY_DUE_DATE — DATE
- DELAY_PENALTY_RATE — DECIMAL(6,3)
- DELIVERY_PLACE — NVARCHAR(500)
- DELIVERY_DUE_DATE — DATE
- WARRANTY_NOTE — NVARCHAR(500)
- DELIVERY_TERMS_CD — VARCHAR(20)
- IP_OWNERSHIP_CD — VARCHAR(20)
- START_DATE — DATE
- END_DATE — DATE
- STATUS_CD — VARCHAR(20) — NOT NULL
- COMPLETION_CD — VARCHAR(20)
- CONTRACT_CLASS — VARCHAR(20) — NOT NULL
- DRAFTER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- BID_AWARD_ID — BIGINT — 외래 키 → TB_BID_AWARD.BID_AWARD_ID
- SOURCE_CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID
- ORIGIN_HASH — CHAR(64)
- TSA_TOKEN — VARBINARY(MAX)
- SIGNED_AT — DATETIME2(0)
- COMPLETED_AT — DATETIME2(0)
- TERMINATE_REASON — NVARCHAR(500)
- REMARK — NVARCHAR(MAX)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_ASSIGN
- ASSIGN_ID — BIGINT — 기본 키 — NOT NULL
- PARTNER_ID — BIGINT — 외래 키 → TB_PARTNER.PARTNER_ID — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- STATUS_CD — VARCHAR(20) — NOT NULL
- ASSIGNED_BY — BIGINT — 외래 키 → TB_USER.USER_ID
- CHANGED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_FILE
- FILE_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- FILE_TYPE — VARCHAR(20) — NOT NULL
- VERSION — INT — NOT NULL
- ATTACHMENT_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- FILE_HASH — CHAR(64)
- TSA_TOKEN — VARBINARY(MAX)
- IS_LATEST — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_HISTORY
- HIST_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- FROM_STATUS — VARCHAR(20)
- TO_STATUS — VARCHAR(20) — NOT NULL
- ACTION — NVARCHAR(40) — NOT NULL
- ACTOR_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- MEMO — NVARCHAR(500)
- ACTOR_IP — VARCHAR(45)
- ACTION_AT — DATETIME2(0) — NOT NULL
TB_CONTRACT_ITEM
- ITEM_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- ITEM_NAME — NVARCHAR(200) — NOT NULL
- SPEC — NVARCHAR(100)
- QTY — DECIMAL(18,2)
- UNIT — NVARCHAR(20)
- UNIT_PRICE — DECIMAL(18,0)
- SUPPLY_AMOUNT — DECIMAL(18,0)
- SORT_NO — INT — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_MEMBER
- MEMBER_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- PARTNER_ID — BIGINT — 외래 키 → TB_PARTNER.PARTNER_ID
- MEMBER_TYPE — VARCHAR(20) — NOT NULL
- SORT_NO — INT
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_PAYMENT
- PAY_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- PAY_SEQ — INT — NOT NULL
- PAY_STAGE — NVARCHAR(40)
- PAY_RATIO — DECIMAL(5,2)
- PAY_AMOUNT — DECIMAL(18,0)
- PAY_DUE_DATE — DATE
- REMARK — NVARCHAR(200)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_CONTRACT_SIGN
- CSIGN_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- TARGET_ID — BIGINT — 외래 키 → TB_SIGN_REQUEST_TARGET.TARGET_ID
- SIGNER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- SIGNER_NAME — NVARCHAR(50)
- SIGNER_SIDE — VARCHAR(20) — NOT NULL
- SIGN_MODE — VARCHAR(20)
- SIGN_SEQ — INT
- SIGN_STATUS — VARCHAR(20) — NOT NULL
- DECLINE_REASON — NVARCHAR(500)
- SIGN_METHOD — VARCHAR(20) — NOT NULL
- AUTH_METHOD — VARCHAR(20)
- AUTH_LOG_ID — BIGINT — 외래 키 → TB_AUTH_LOG.AUTH_LOG_ID
- CERT_TYPE — VARCHAR(20)
- CERT_SUBJECT — NVARCHAR(200)
- CERT_ISSUER_DN — NVARCHAR(200)
- CERT_SERIAL — VARCHAR(80)
- CERT_POLICY_OID — VARCHAR(100)
- CERT_NOT_BEFORE — DATETIME2(0)
- CERT_NOT_AFTER — DATETIME2(0)
- SIGN_ALG — VARCHAR(40)
- SIGN_PLATFORM — VARCHAR(20)
- SIGN_CHANNEL — VARCHAR(20)
- SIGN_DATA — VARBINARY(MAX)
- SIGN_HASH — CHAR(64)
- TSA_TOKEN — VARBINARY(MAX)
- REVOCATION_CHECKED_YN — CHAR(1) — NOT NULL
- REVOCATION_RESPONSE — VARBINARY(MAX)
- SIGNER_IP — VARCHAR(45)
- SIGNED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
TB_FAQ
- FAQ_ID — BIGINT — 기본 키 — NOT NULL
- CATEGORY — VARCHAR(20) — NOT NULL
- QUESTION — NVARCHAR(500) — NOT NULL
- ANSWER — NVARCHAR(MAX)
- SORT_NO — INT — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_FORM_TEMPLATE
- FORM_ID — BIGINT — 기본 키 — NOT NULL
- FORM_NAME — NVARCHAR(100) — NOT NULL
- CONTRACT_TYPE — VARCHAR(20) — NOT NULL
- VERSION — VARCHAR(20) — NOT NULL
- EFORM_KEY — NVARCHAR(200)
- FORM_FILE_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- USE_YN — CHAR(1) — NOT NULL
- DESCRIPTION — NVARCHAR(MAX)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_FORM_TEMPLATE_HIST
- FORM_ID — BIGINT — NOT NULL
- FORM_NAME — NVARCHAR(100) — NOT NULL
- CONTRACT_TYPE — VARCHAR(20) — NOT NULL
- VERSION — VARCHAR(20) — NOT NULL
- EFORM_KEY — NVARCHAR(200)
- FORM_FILE_ID — BIGINT
- USE_YN — CHAR(1) — NOT NULL
- DESCRIPTION — NVARCHAR(MAX)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
- SYS_START_AT — DATETIME2(7) — NOT NULL
- SYS_END_AT — DATETIME2(7) — NOT NULL
TB_FORM_VERSION
- VERSION_ID — BIGINT — 기본 키 — NOT NULL
- FORM_ID — BIGINT — 외래 키 → TB_FORM_TEMPLATE.FORM_ID — NOT NULL
- VERSION — VARCHAR(20) — NOT NULL
- CHANGE_SUMMARY — NVARCHAR(500)
- FORM_XML_FILE_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- VERSION_STATUS — VARCHAR(20) — NOT NULL
- MODIFIED_BY — BIGINT — 외래 키 → TB_USER.USER_ID
- MODIFIED_AT — DATETIME2(0) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_INQUIRY
- INQUIRY_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- INQUIRY_TYPE — VARCHAR(20)
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENT — NVARCHAR(MAX)
- ATTACHMENT_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- STATUS — VARCHAR(20) — NOT NULL
- ANSWER — NVARCHAR(MAX)
- ANSWER_DRAFT_YN — CHAR(1) — NOT NULL
- ANSWERED_BY — BIGINT — 외래 키 → TB_USER.USER_ID
- ANSWERED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_MANUAL
- MANUAL_ID — BIGINT — 기본 키 — NOT NULL
- TARGET — VARCHAR(20) — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- VERSION — VARCHAR(20) — NOT NULL
- ATTACHMENT_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- SORT_NO — INT — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_NOTICE
- NOTICE_ID — BIGINT — 기본 키 — NOT NULL
- NOTICE_TYPE — VARCHAR(20) — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENT — NVARCHAR(MAX)
- PIN_YN — CHAR(1) — NOT NULL
- POST_START_DATE — DATE — NOT NULL
- POST_END_DATE — DATE
- VIEW_CNT — INT — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_NOTIFICATION
- NOTI_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID
- RECEIVER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- RECEIVER_ADDR — NVARCHAR(200)
- CHANNEL_CD — VARCHAR(20) — NOT NULL
- NOTI_TYPE — VARCHAR(20) — NOT NULL
- TITLE — NVARCHAR(MAX)
- CONTENT — NVARCHAR(MAX)
- SEND_STATUS — VARCHAR(20) — NOT NULL
- FAIL_REASON — NVARCHAR(500)
- FALLBACK_OF — BIGINT — 외래 키 → TB_NOTIFICATION.NOTI_ID
- RESEND_CNT — INT — NOT NULL
- SCHEDULED_AT — DATETIME2(0)
- SENT_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_PARTNER
- PARTNER_ID — BIGINT — 기본 키 — NOT NULL
- BIZ_REG_NO — VARCHAR(12) — NOT NULL
- CORP_NAME — NVARCHAR(100) — NOT NULL
- CORP_REG_NO — VARCHAR(14)
- BIZ_TYPE — NVARCHAR(60)
- CEO_NAME — NVARCHAR(50)
- TEL_NO — VARCHAR(20)
- ZIP_CODE — VARCHAR(6)
- ADDR1 — NVARCHAR(200)
- ADDR2 — NVARCHAR(200)
- BIZ_LICENSE_FILE — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- SYNC_SRC — VARCHAR(20)
- SYNC_AT — DATETIME2(0)
- MASTER_PARTNER_ID — VARCHAR(50)
- STATUS_CD — VARCHAR(20) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_ROLE_PERM
- ROLE_PERM_ID — BIGINT — 기본 키 — NOT NULL
- ROLE_CD — VARCHAR(20) — NOT NULL
- MENU_CD — VARCHAR(30) — NOT NULL
- PERM_LEVEL — VARCHAR(10) — NOT NULL
- DATA_SCOPE — VARCHAR(20)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_SIGN_REQUEST
- SIGN_REQ_ID — BIGINT — 기본 키 — NOT NULL
- CONTRACT_ID — BIGINT — 외래 키 → TB_CONTRACT.CONTRACT_ID — NOT NULL
- SIGN_MODE — VARCHAR(20) — NOT NULL
- CHANNEL_CD — VARCHAR(20) — NOT NULL
- REQ_MESSAGE — NVARCHAR(MAX)
- STATUS_CD — VARCHAR(20) — NOT NULL
- RESEND_CNT — INT — NOT NULL
- TOKEN_TTL_MIN — INT — NOT NULL
- REQUESTED_BY — BIGINT — 외래 키 → TB_USER.USER_ID
- REQUESTED_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_SIGN_REQUEST_TARGET
- TARGET_ID — BIGINT — 기본 키 — NOT NULL
- SIGN_REQ_ID — BIGINT — 외래 키 → TB_SIGN_REQUEST.SIGN_REQ_ID — NOT NULL
- SIGNER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- SIGNER_NAME — NVARCHAR(50)
- SIGNER_EMAIL — NVARCHAR(100)
- SIGNER_MOBILE — VARCHAR(20)
- SEQ_NO — INT
- TARGET_ROLE — VARCHAR(20)
- SIGN_STATUS — VARCHAR(20) — NOT NULL
- SIGN_TOKEN — VARCHAR(200)
- TOKEN_ISSUED_AT — DATETIME2(0)
- TOKEN_EXPIRES_AT — DATETIME2(0)
- TOKEN_USED_YN — CHAR(1) — NOT NULL
- TOKEN_USED_AT — DATETIME2(0)
- TOKEN_REISSUE_CNT — INT — NOT NULL
- ACTIVATED_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_SIGN_SESSION
- SESSION_ID — BIGINT — 기본 키 — NOT NULL
- TARGET_ID — BIGINT — 외래 키 → TB_SIGN_REQUEST_TARGET.TARGET_ID — NOT NULL
- SIGN_TOKEN — VARCHAR(200) — NOT NULL
- SESSION_KEY — VARCHAR(100)
- SESSION_STATUS — VARCHAR(20) — NOT NULL
- CLIENT_IP — VARCHAR(45)
- USER_AGENT — NVARCHAR(500)
- DEVICE_TYPE — VARCHAR(20)
- OS_TYPE — VARCHAR(20)
- INAPP_YN — CHAR(1) — NOT NULL
- INAPP_SOURCE — VARCHAR(20)
- BROWSER_SWITCHED_YN — CHAR(1) — NOT NULL
- RESTORED_YN — CHAR(1) — NOT NULL
- ACCESS_CNT — INT — NOT NULL
- DRAFT_DATA — NVARCHAR(MAX)
- DRAFT_SAVED_AT — DATETIME2(0)
- STARTED_AT — DATETIME2(0) — NOT NULL
- LAST_ACCESS_AT — DATETIME2(0)
- ENDED_AT — DATETIME2(0)
TB_TERMS
- TERMS_ID — BIGINT — 기본 키 — NOT NULL
- TERMS_TYPE — VARCHAR(30) — NOT NULL
- TERMS_NAME — NVARCHAR(100) — NOT NULL
- VERSION — VARCHAR(20) — NOT NULL
- CONTENT — NVARCHAR(MAX) — NOT NULL
- REQUIRED_YN — CHAR(1) — NOT NULL
- EFFECTIVE_FROM — DATE — NOT NULL
- EFFECTIVE_TO — DATE
- SORT_NO — INT — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_TERMS_AGREE
- AGREE_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID
- TERMS_ID — BIGINT — 외래 키 → TB_TERMS.TERMS_ID — NOT NULL
- AGREE_YN — CHAR(1) — NOT NULL
- AGREED_AT — DATETIME2(0) — NOT NULL
- AGREED_IP — VARCHAR(45)
- AGREED_UA — NVARCHAR(500)
- WITHDRAWN_AT — DATETIME2(0)
TB_USER
- USER_ID — BIGINT — 기본 키 — NOT NULL
- PARTNER_ID — BIGINT — 외래 키 → TB_PARTNER.PARTNER_ID
- USER_TYPE — VARCHAR(20) — NOT NULL
- LOGIN_ID — VARCHAR(8) — NOT NULL
- PASSWORD — VARCHAR(200)
- SSO_KEY — VARCHAR(100)
- USER_NAME — NVARCHAR(50) — NOT NULL
- EMAIL — NVARCHAR(100) — NOT NULL
- MOBILE_NO — VARCHAR(20)
- EMP_NO — VARCHAR(20)
- DEPT_NAME — NVARCHAR(60)
- POSITION — NVARCHAR(40)
- ROLE_CD — VARCHAR(20) — NOT NULL
- STATUS_CD — VARCHAR(20) — NOT NULL
- PWD_FAIL_CNT — INT — NOT NULL
- PWD_CHG_AT — DATETIME2(0)
- PWD_INIT_YN — CHAR(1) — NOT NULL
- LOCKED_AT — DATETIME2(0)
- LAST_LOGIN_AT — DATETIME2(0)
- JOIN_APPROVED_BY — BIGINT
- JOIN_APPROVED_AT — DATETIME2(0)
- JOIN_REJECT_REASON — NVARCHAR(500)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_USER_ROLE
- USER_ROLE_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- ROLE_CD — VARCHAR(20) — NOT NULL
- IS_PRIMARY — CHAR(1) — NOT NULL
- GRANTED_BY — BIGINT — 외래 키 → TB_USER.USER_ID
- GRANTED_AT — DATETIME2(0) — NOT NULL
- EXPIRES_AT — DATETIME2(0)
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL
TB_USER_SIGNATURE
- SIGN_ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — 외래 키 → TB_USER.USER_ID — NOT NULL
- SIGN_METHOD — VARCHAR(20) — NOT NULL
- SIGN_NAME — NVARCHAR(40)
- IMG_ATTACHMENT_ID — BIGINT — 외래 키 → TB_ATTACHMENT.ATTACHMENT_ID
- IS_DEFAULT — CHAR(1) — NOT NULL
- CREATED_BY — BIGINT
- CREATED_AT — DATETIME2(0) — NOT NULL
- UPDATED_BY — BIGINT
- UPDATED_AT — DATETIME2(0)
- DEL_YN — CHAR(1) — NOT NULL