17-Jinus-KTB-3

Tables (27)

Answer (ANSWER)

  • Answer Ideitifier (answer_id) — BIGINT — Primary key — NOT NULL
  • Question Identifier (question_id) — BIGINT — Foreign key → Question.Question Identifier — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Answer Content (answer_content) — TEXT
  • AI Feedback (answer_ai_feedback) — TEXT

Answer Hash Tag (ANSWER_HASHTAG)

  • Answer Ideitifier (answer_id) — BIGINT — Foreign key → Answer.Answer Ideitifier — NOT NULL
  • Hash Tag Identifier (tag_id) — BIGINT — Foreign key → HashTag.Hash Tag Identifier — NOT NULL

Answer Metric (ANSWER_METRIC)

  • Answer Ideitifier (answer_id) — BIGINT — Foreign key → Answer.Answer Ideitifier — NOT NULL
  • Metric Identifier (metric_id) — BIGINT — Foreign key → Metric.Metric Identifier — NOT NULL
  • Metric Score Number (metric_score) — INT
  • Answer Metric Create Time (metric_create_time) — TIMESTAMP
  • Answer Metric Update Time (metric_update_time) — TIMESTAMP

Answer Session (ANSWER_SESSION)

  • Session Identifier (answer_session_id) — VARCHAR(50) — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Session Mode (answer_session_mode) — VARCHAR(20)
  • Session Status (answer_session_status) — VARCHAR(20)
  • Current Session Depth (answer_session_current_depth) — INT
  • Create At (created_at) — TIMESTAMP
  • Update At (updated_at) — TIMESTAMP

HashTag (HASHTAG)

  • Hash Tag Identifier (tag_id) — BIGINT — Primary key — NOT NULL
  • Hash Tag Name (tag_nm) — VARCHAR(100)
  • Hash Tag Description (tag_desc) — VARCHAR(255)

Metric (METRIC)

  • Metric Identifier (metric_id) — BIGINT — Primary key — NOT NULL
  • Metric Name (metric_nm) — VARCHAR(30)
  • Metric Description (metric_desc) — VARCHAR(255)
  • Create At (create_at) — TIMESTAMP
  • Update At (update_at) — TIMESTAMP
  • Use Yes/No (use_yn) — BOOLEAN

Project Hash Tag (PRJ_HASHTAG)

  • Project Identifier (prj_id) — BIGINT — Foreign key → project.Project Identifier — NOT NULL
  • Hash Tag Identifier (tag_id) — BIGINT — Foreign key → HashTag.Hash Tag Identifier — NOT NULL

Question (QUESTION)

  • Question Identifier (question_id) — BIGINT — Primary key — NOT NULL
  • Question Content (question_content) — VARCHAR(200)
  • Question Type Code (question_type_cd) — VARCHAR(50)
  • Question Category (question_ctg) — VARCHAR(50) — Foreign key → Question Detail category.Question Category
  • Create At (question_create_at) — TIMESTAMP
  • Update At (question_update_at) — TIMESTAMP
  • Delete At (question_delete_at) — TIMESTAMP
  • Use Yes/No (use_yn) — BOOLEAN

Question Detail category (QUESTION_CATEGORY)

  • Question Category (question_ctg) — VARCHAR(50) — Primary key
  • Categry Description (description) — VARCHAR(30)

Question Hash Tag (QUESTION_HASHTAG)

  • Question Identifier (question_id) — BIGINT — Foreign key → Question.Question Identifier — NOT NULL
  • Hash Tag Identifier (tag_id) — BIGINT — Foreign key → HashTag.Hash Tag Identifier — NOT NULL

Question Hierarchy (QUESTION_HIER)

  • Question Tree Identifier (question_tree_id) — BIGINT — Primary key — NOT NULL
  • Question Identifier (question_id) — BIGINT — Foreign key → Question.Question Identifier — NOT NULL
  • Left Number (lft_no) — BIGINT
  • Right Number (rgt_no) — BIGINT
  • Depth Number (depth_no) — BIGINT
  • Order Number (ord_no) — BIGINT
  • Create At (create_at) — TIMESTAMP

User Notification (USER_NOTIFICATION)

  • User Notification Identifier (user_noti_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Notification Identifier (noti_id2) — BIGINT — Foreign key → noti.Notification Identifier — NOT NULL
  • Read Flag (user_noti_is_read) — BOOLEAN
  • Read Timestamp (read_at) — TIMESTAMP
  • Create Time (created_at) — TIMESTAMP

User OAuth RTR (USER_OAUTH_REFRESH)

  • Refresh Token Identifier (refresh_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Token Plain Text Hash Value (refresh_token_hash) — VARCHAR(64)
  • Token Family Identifier (refresh_family_id) — BIGINT
  • Used (refresh_used) — BOOLEAN
  • Used Time (refresh_used_at) — TIMESTAMP
  • Exprire Time (refresh_expires_at) — TIMESTAMP
  • Create Time (refresh_create_at) — TIMESTAMP

User OAuth RTR Family (USER_OAUTH_RTR_FAMILY)

  • Family Identifier (family_id) — BIGINT — Primary key — NOT NULL
  • Family UUID (family_uuid) — VARCHAR(36)
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Device Info (family_device_info) — VARCHAR(1000)
  • Client IPv4/IPv6 (family_client_ip) — VARCHAR(45)
  • Last Used Time (family_last_used_at) — TIMESTAMP
  • Create Time (family_create_at) — TIMESTAMP
  • Expire Time (family_expires_at) — TIMESTAMP
  • Revoke Status (family_revoked) — BOOLEAN
  • Revoke Time (family_revoked_at) — TIMESTAMP
  • Revoke Reason (family_revoked_reason) — VARCHAR(100)

account (USER_ACCOUNT)

  • Account Identifier (account_id) — BIGINT — Primary key — NOT NULL
  • File Identifier (file_id) — BIGINT — Foreign key → file.File Identifier — NOT NULL
  • Account Email (account_email) — VARCHAR(320)
  • Nickname (account_nick_nm) — VARCHAR(800) — Kakao 최대 닉네임 200글자
  • Create At (account_create_at) — TIMESTAMP
  • Delete At (account_delete_at) — TIMESTAMP
  • Accoun status code (account_status_cd) — VARCHAR(10)
  • Account Last Login Time (account_last_login_at) — TIMESTAMP

campaign (CAMPAIGN)

  • Campaign Identifier (campaign_id) — BIGINT — Primary key — NOT NULL
  • Notice Identifier (notice_id) — BIGINT — Foreign key → notice.Notice Identifier — NOT NULL
  • Template Identifier (campaign_template_id) — BIGINT
  • Campaign Type Code (campaign_type_cd) — VARCHAR(20)
  • Campaign Key (campaign_key) — VARCHAR(200)
  • Status Code (campaign_status_cd) — VARCHAR(20)
  • Scheduled At (campaign_scheduled_at) — TIMESTAMP
  • Create Time (campaign_created_at) — TIMESTAMP
  • Start Time (campaign_started_at) — TIMESTAMP
  • Complete Time (campaign_completed_at) — TIMESTAMP
  • Update Time (campaign_updated_at) — TIMESTAMP

device (USER_DEVICE)

  • Device Identifier (device_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Platform Code (device_platform_cd) — VARCHAR(20)
  • Push Token (device_push_token) — VARCHAR(500)
  • Token Update at (device_token_updated_at) — TIMESTAMP
  • Push Type (device_push_type_cd) — VARCHAR(20)
  • Push EndPoint (device_push_endpoint) — VARCHAR(2000)
  • Push p256dh (device_push_p256dh) — VARCHAR(256)
  • Push Auth (device_push_auth) — VARCHAR(256)
  • Push Expired At (device_push_expired_at) — TIMESTAMP
  • Last Seen At (device_last_seen_at) — TIMESTAMP
  • Use Yes/No (use_yn) — BOOLEAN
  • Create Time (device_created_at) — TIMESTAMP

file (FILE)

  • File Identifier (file_id) — BIGINT — Primary key — NOT NULL
  • Original File name (file_original_name) — VARCHAR(500)
  • Store File Name (file_store_name) — VARCHAR(500)
  • File Path (file_path) — VARCHAR(1000)
  • File Extension (file_ext) — VARCHAR(20)
  • File Hash Value (file_hash) — CHAR(64)
  • File Mime Type (file_mime_type) — VARCHAR(100)
  • File Storage Type (file_storage_type) — VARCHAR(20)
  • File URL (file_url) — VARCHAR(2000)
  • File Create Time (file_create_at) — TIMESTAMP
  • File Delete Time (file_delete_at) — TIMESTAMP

noti (NOTIFICATION)

  • Notification Identifier (noti_id) — BIGINT — Primary key — NOT NULL
  • Campaign Identifier (campaign_id) — BIGINT — Foreign key → campaign.Campaign Identifier — NOT NULL
  • Template Identifier (template_id) — BIGINT — Foreign key → noti_template.Template Identifier — NOT NULL
  • Channel Code (noti_channel_cd) — VARCHAR(20)
  • Payload JSON (noti_payload_json) — JSON
  • Create Time (created_at) — TIMESTAMP

noti_delivery_attempt (NOTIFICATION_DELIVERY_TARGET)

  • Attempt Identifier (noti_devilery_attempt_id) — BIGINT — Primary key — NOT NULL
  • Target Identifier (target_id) — BIGINT — Foreign key → noti_target.Target Identifier — NOT NULL
  • Attempt Number (noti_devilery_attempt_no) — BIGINT
  • Result Code (noti_devilery_result_cd) — VARCHAR(20)
  • Provider Error Code (noti_devilery_provider_error_cd) — VARCHAR(50)
  • Provider Error Message (noti_devilery_provider_error_msg) — VARCHAR(500)
  • Attempt At (noti_devilery_attempt_at) — TIMESTAMP
  • Latency_ms (noti_devilery_latency_ms) — INT

noti_pref (NOTIFICATION_PREFERENCE)

  • Preference Identifier (noti_pref_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Notification Type Code (noti_pref_type_cd) — VARCAHR(50)
  • Push Enabel (noti_pref_push_enabled) — BOOLEAN
  • Create Time (created_at) — TIMESTAMP
  • Update Time (updated_at) — TIMESTAMP

noti_target (NOTIFICATION_TARGET)

  • Target Identifier (noti_target_id) — BIGINT — Primary key — NOT NULL
  • Notification Identifier (noti_id) — BIGINT — Foreign key → noti.Notification Identifier — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Device Identifier (device_id) — BIGINT — Foreign key → device.Device Identifier — NOT NULL
  • Provider Code (noti_target_provider_cd) — VARCHAR(20)
  • Status Code (noti_target_status_cd) — VARCHAR(20)
  • Dedepulicate Key (noti_target_dedupe_key) — VARCHAR(200)
  • Queued at (noti_target_queued_at) — TIMESTAMP
  • Sent At (noti_target_sent_at) — TIMESTAMP
  • Create Time (created_at) — TIMESTAMP

noti_template (NOTIFICATION_TEMPLATE)

  • Template Identifier (noti_template_id) — BIGINT — Primary key — NOT NULL
  • Template Code (noti_template_cd) — VARCHAR(50)
  • Title (noti_template_title) — VARCHAR(200)
  • Body (noti_template_body) — VARCHAR(500)
  • Data Json Schema (noti_template_data_json_schema) — JSON
  • Use Yes/No (use_yn) — BOOLEAN
  • Create Time (created_at) — TIMESTAMP
  • Update Time (updated_at) — TIMESTAMP

notice (NOTICE)

  • Notice Identifier (notice_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • Title (notice_title) — VARCHAR(200)
  • Body (notice_body) — TEXT
  • Published At (notice_published_at) — TIMESTAMP
  • Status Code (notice_status_cd) — VARCHAR(20)
  • Create Time (created_at) — TIMESTAMP
  • Update Time (updated_at) — TIMESTAMP
  • Delete Time (deleted_at) — TIMESTAMP

portfolio (USER_PTF)

  • Portfolio Identifier (ptf_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • CreateAt (ptf_create_at) — TIMESTAMP
  • DeleteAt (ptf_delete_at) — TIMESTAMP
  • UpdateAt (ptf_update_at) — TIMESTAMP

project (USER_PRJ)

  • Project Identifier (prj_id) — BIGINT — Primary key — NOT NULL
  • Portfolio Identifier (ptf_id) — BIGINT — Foreign key → portfolio.Portfolio Identifier — NOT NULL
  • File Identifier (arch_file_id) — BIGINT — Foreign key → file.File Identifier — NOT NULL
  • Name (prj_nm) — VARCHAR(500) — 프로젝트 제목 150자 이내 작성
  • Acheivement (achv_txt) — TEXT
  • CreateAt (prj_create_at) — TIMESTAMP
  • UpdateAt (prj_update_at) — TIMESTAMP
  • DeleteAt (prj_delete_at) — TIMESTAMP
  • Use Yes/No (use_yn) — BOOLEAN

user oauth (USER_OAUTH)

  • OAuth Identifier (oauth_id) — BIGINT — Primary key — NOT NULL
  • Account Identifier (account_id) — BIGINT — Foreign key → account.Account Identifier — NOT NULL
  • OAuth Provider name (oauth_provider_nm) — VARCHAR(30)
  • OAuth Provider Identifier (oauth_provider_user_id) — VARCHAR(255)
  • OAuth First Connection Time (oauth_connected_at) — TIMESTAMP
  • Last Login Time (oauth_last_login_at) — TIMESTAMP
  • OAuth Unlink Time (oauth_unliked_at) — TIMESTAMP