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