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