팬텍_전자계약_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