darp

Tables (10)

DARP_ADMIN_MEMO

  • MEMO_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • MEMO_TEXT — TEXT — NOT NULL
  • CREATED_BY — VARCHAR(50) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL

DARP_BOARD

  • BOARD_ID — BIGINT — Primary key — NOT NULL
  • BOARD_TYPE — VARCHAR(20) — NOT NULL
  • TITLE — VARCHAR(200) — NOT NULL
  • CATEGORY_CODE — VARCHAR(30)
  • SUMMARY — VARCHAR(500)
  • CONTENT — TEXT — NOT NULL
  • IS_PINNED — CHAR(1)
  • IS_PUBLISHED — CHAR(1) — NOT NULL
  • VIEW_COUNT — INT — NOT NULL
  • CREATED_BY — VARCHAR(50) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME

DARP_GUEST_MAGIC_LINK

  • TOKEN_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • TOKEN — VARCHAR(100) — NOT NULL
  • EXPIRES_AT — DATETIME — NOT NULL
  • USED_AT — DATETIME
  • CREATED_AT — DATETIME — NOT NULL

DARP_GUEST_VERIFY_LOG

  • LOG_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_NO_INPUT — VARCHAR(30) — NOT NULL
  • GUEST_PHONE_INPUT — VARCHAR(20) — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID
  • SUCCESS_YN — CHAR(1) — NOT NULL
  • IP_ADDRESS — VARCHAR(45)
  • ATTEMPTED_AT — DATETIME — NOT NULL

DARP_IOT_REQUEST

  • IOT_REQUEST_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_NO — VARCHAR(30) — NOT NULL
  • MEMBER_ID — VARCHAR(50)
  • COMPANY_TYPE_CODE — VARCHAR(20) — NOT NULL
  • COMPANY_NAME — VARCHAR(200) — NOT NULL
  • MAIN_PRODUCT — VARCHAR(500) — NOT NULL
  • PRODUCT_FEATURE — VARCHAR(500)
  • REVENUE — VARCHAR(100) — NOT NULL
  • EMPLOYEE_COUNT — VARCHAR(50) — NOT NULL
  • FOUNDED_YEAR — VARCHAR(10) — NOT NULL
  • CONTACT_DEPT — VARCHAR(100) — NOT NULL
  • CONTACT_NAME — VARCHAR(100) — NOT NULL
  • CONTACT_POSITION — VARCHAR(100) — NOT NULL
  • CONTACT_PHONE — VARCHAR(20) — NOT NULL
  • CONTACT_EMAIL — VARCHAR(200) — NOT NULL
  • REQUIREMENT_TEXT — TEXT
  • CREATED_AT — DATETIME — NOT NULL

DARP_NOTIFICATION_LOG

  • NOTI_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • NOTI_TYPE_CODE — VARCHAR(30) — NOT NULL
  • RECEIVER_EMAIL — VARCHAR(200) — NOT NULL
  • SEND_STATUS — VARCHAR(20) — NOT NULL
  • SENT_AT — DATETIME — NOT NULL

DARP_REQUEST

  • REQUEST_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_NO — VARCHAR(30) — NOT NULL
  • MEMBER_ID — VARCHAR(50)
  • COMPANY_ID — VARCHAR(50)
  • COMPANY_NAME — VARCHAR(200)
  • REQUEST_TITLE — VARCHAR(200) — NOT NULL
  • REQUEST_PURPOSE — TEXT
  • DATA_DESCRIPTION — TEXT
  • REQUEST_NOTE — TEXT
  • STATUS_CODE — VARCHAR(30) — NOT NULL
  • SUPPLEMENT_REASON — TEXT
  • REJECT_REASON — TEXT
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME

DARP_REQUEST_FILE

  • FILE_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • FILE_TYPE — VARCHAR(20) — NOT NULL
  • ORIGINAL_FILE_NAME — VARCHAR(300) — NOT NULL
  • FILE_EXT — VARCHAR(20) — NOT NULL
  • FILE_SIZE — BIGINT — NOT NULL
  • S3_BUCKET — VARCHAR(100) — NOT NULL
  • S3_OBJECT_KEY — VARCHAR(500) — NOT NULL
  • UPLOAD_STATUS — VARCHAR(20) — NOT NULL
  • UPLOAD_METHOD — VARCHAR(20) — NOT NULL
  • VERSION_NO — INT — NOT NULL
  • IS_LATEST — CHAR(1) — NOT NULL
  • RESULT_SUMMARY — TEXT
  • UPLOADED_BY — VARCHAR(50) — NOT NULL
  • DELETE_YN — CHAR(1) — NOT NULL
  • DELETED_BY — VARCHAR(50)
  • DELETED_AT — DATETIME
  • CREATED_AT — DATETIME — NOT NULL

DARP_REQUEST_GUEST

  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • GUEST_NAME — VARCHAR(100) — NOT NULL
  • GUEST_PHONE — VARCHAR(20) — NOT NULL
  • GUEST_EMAIL — VARCHAR(200) — NOT NULL
  • GUEST_COMPANY_NAME — VARCHAR(200) — NOT NULL
  • BUSINESS_REG_NO — VARCHAR(20) — NOT NULL
  • PRIVACY_AGREE_YN — CHAR(1) — NOT NULL
  • PRIVACY_AGREE_AT — DATETIME — NOT NULL
  • MATCH_STATUS — VARCHAR(20) — NOT NULL
  • MATCHED_MEMBER_ID — VARCHAR(50)
  • MATCHED_AT — DATETIME

DARP_REQUEST_STATUS_HIST

  • HIST_ID — BIGINT — Primary key — NOT NULL
  • REQUEST_ID — BIGINT — Foreign key → DARP_REQUEST.REQUEST_ID — NOT NULL
  • FROM_STATUS_CODE — VARCHAR(30)
  • TO_STATUS_CODE — VARCHAR(30) — NOT NULL
  • SUPPLEMENT_TARGET_CODES — VARCHAR(100)
  • CHANGED_BY — VARCHAR(50) — NOT NULL
  • CHANGED_AT — DATETIME — NOT NULL