ECHOMAKR_USER_ERD
Tables (23)
user_inquiry (update : 24.05.24) (user_inquiry)
- INQ_ID — BIGINTUNSIGNED — Primary key — NOT NULL — inquiry System ID
- USER_ID — IntegerUnsigned — NOT NULL — indexing IDX_1, user system ID
- USER_EMAIL — varchar(80) — NOT NULL — User email
- INQ_CATEGORY_GCD — varchar(24) — NOT NULL — indexing IDX_1, inquiry category , Refer refer USR-COM-VAL : INQ_CATEGORY_GCD
- IS_REPLIED — TINYINTunsigned — NOT NULL — indexing IDX_1, inquiry reply flag, 1 : replied
- INQ_TITLE — varchar(100) — NOT NULL — inquiry title
- INQ_CONTENTS — varchar(500) — NOT NULL — Inquiry contents
- INQ_TARGET_SYS — varchar(24) — inquiry target system , refer SYS-FIX-VAL : System-Service Type
- INQ_TIME — datetime — NOT NULL — inquiry time UTC+0
- UPDATE_TIME — datetime — last updated time, UTC+0
- CREATE_TIME — datetime — NOT NULL — created time, UTC+0
user_inquiry_reply ( update : 24.05.24) (user_inquiry_reply)
- REPLY_ID — BIGINTUNSIGNED — Primary key — NOT NULL — reply System ID of inquiry
- INQ_ID — BIGINTUNSIGNED — Foreign key → user_inquiry (update : 24.05.24).INQ_ID — NOT NULL — indexing IDX_1, inquiry System ID
- REPLIED_USER_ID — IntegerUnsigned — NOT NULL — indexing IDX_1, replied admin user system id
- REPLIED_CONTENTS — varchar(500) — NOT NULL — reply contents
- REPLIED_TM — DATETIME — NOT NULL — last replied time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
user_notification only for service announcement ( not include system announce) ( update: 24.05.27) (user_notification)
- NOTI_ID — BIGINTUNSIGNED — Primary key — NOT NULL — notification System ID
- USER_ID — IntegerUnsigned — NOT NULL — indexing IDX_1, user system id
- NOTI_EVENT_TYPE_GCD — varchar(24) — NOT NULL
- IS_CHECKED — TINYINTunsigned — NOT NULL — indexing IDX_1, checked flag , if 1 , it is checked
- NOTI_TITLE — varchar(150) — NOT NULL — notification title
- NOTIFICATION — varchar(300) — notification contents , data format is json , we need to define data json formation
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
workspace ( update : 24.05.21) (workspace)
- WS_ID — IntegerUnsigned — Primary key — NOT NULL — Private Workspace System ID, format is according ID rule
- WS_P_ID — char(10) — NOT NULL — , Unique UQ_1, Public Workspace ID for external exposure ID, , format is according ID rule
- WS_NAME — varchar(40) — NOT NULL — , Unique UQ_2, Workspace name,
- PERM_BRING_SITE_LIST — varchar(60) — NOT NULL — permission list of bring site, enum array of bring site
- PERM_EXPORT__LIST (PERM_EXPORT_LIST) — varchar(30) — NOT NULL — permission list of export file format, enum array of export file format
- PERM_IMPORT__LIST (PERM_IMPORT_LIST) — varchar(10) — NOT NULL — permission list of import file typ/ category , enum array of import file typ/ category , ex ) import translated excel f…
- PERM_OCR — TINYINTunsigned — NOT NULL — permission of OCR , enum value ( internal OCR Engine or Google vision)
- IS_PERM_AUTO_TRANS — TINYINTunsigned — NOT NULL — permission flag of auto translation function, 0: can't use , 1 : can use
- IS_PERM_BULK_UPLOAD — TINYINTunsigned — NOT NULL — permission flag of bulk upload funtion , 0: can't use , 1 : can use
- IS_PERM_PSE — TINYINTunsigned — NOT NULL — permission flag of PSE tool for designer , 0: can't use , 1 : can use
- IS_PERM_FILE_MNR — TINYINTunsigned — NOT NULL — permission flag of file manger tool , 0: can't use , 1 : can use
- LIMIT_USAGE — Integer unsigned — NOT NULL — usage limits, 0: unlimited
- WS_HOME_URL — varchar(60) — NOT NULL — , Unique UQ_3, directly access url for their workspace home screen, we need to special accessing url rule for directly…
- UPDATED_BY_ID — Integer unsigned — NOT NULL — updated by "user system id"
- UPDATED_TM — DATETIME — NOT NULL — updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_ep_comment (update : 24.05.24) (ws_ep_comment)
- COMMENT_ID — BIGINTUNSIGNED — Primary key — NOT NULL — episode comment System ID
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — indexing IDX_1, episode System ID
- IS_RESOLVED — TINYINTunsigned — NOT NULL — indexing IDX_1, resolved flag , if 1 , it is resolved
- COMBINED_X — int — NOT NULL — Combined X coordinate
- COMBINED_Y — int — NOT NULL — Combined Y coordinate
- WIDTH — int — NOT NULL — Width of the vision box
- HEIGHT — int — NOT NULL — Height of the vision box
- COMMENT — varchar(200) — NOT NULL — text
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — indexing IDX_1, created by "user system id"
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
- MARK_CAPTURE_IMG_URL — varchar(140) — capture image of marked area for feedback
ws_ep_comment_reply (update : 24.05.24) (ws_ep_comment_reply)
- C_REPLY_ID — BIGINTUNSIGNED — Primary key — NOT NULL — comment reply System ID
- COMMENT_ID — BIGINTUNSIGNED — Foreign key → ws_ep_comment (update : 24.05.24).COMMENT_ID — NOT NULL — indexing IDX_1, episode comment System ID
- REPLY_TEXT — varchar(200) — NOT NULL — text
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — indexing IDX_1, created by "user system id"
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
- MARK_CAPTURE_IMG_URL — varchar(140) — capture image of marked area for feedback
ws_ep_comment_tags (24.05.24) (ws_ep_comment_tags)
- EP_COMNT_TAG_GCD — varchar(24) — Primary key — NOT NULL — episode comment tag , Refer refer USR-COM-VAL : EP_COMNT_TAG_GCD
- COMMENT_ID — BIGINTUNSIGNED — Foreign key → ws_ep_comment (update : 24.05.24).COMMENT_ID — NOT NULL — episode comment System ID
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — episode System ID,
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — created by "user system id"
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_ep_text_box
- TXT_ID — BIGINTUNSIGNED — Primary key — NOT NULL — Text System ID
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — indexing IDX_1, episode System ID
- BOX_CREATION_TYPE — TINYINTunsigned — NOT NULL — indexing IDX_1, Text box creation type ,Refer SYS-FIX-VAL : User Service-Box Creation type
- COMBINED_X — int — NOT NULL — Combined X coordinate
- COMBINED_Y — int — NOT NULL — Combined Y coordinate
- WIDTH — int — NOT NULL — Width of the vision box
- HEIGHT — int — NOT NULL — Height of the vision box
- IS_ORIGINAL — TINYINTunsigned — NOT NULL — txt flag of original side , if text is on original side, value is 1
- TEXT — varchar(1500) — NOT NULL — text
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated by "user system id"
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_ep_text_box_relation (ws_text_box_relation)
- EPISODE_ID — BIGINTUNSIGNED — Primary key — NOT NULL — episode System ID
- TXT_ID — BIGINTUNSIGNED — Primary key — NOT NULL — Main Text System ID
- RELATED_TAX_ID — BIGINTUNSIGNED — Primary key — NOT NULL — related text box system id with Main text system ID
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_episode ( update : 24.05.21) (ws_episode)
- EPISODE_ID — BIGINTUNSIGNED — Primary key — NOT NULL — indexing IDX_1, Private episode System ID, , format is according ID rule
- EPISODE_P_ID — varchar(20) — NOT NULL — Unique UQ_1, Public episode ID for external exposure ID, , format is according ID rule
- SERIES_ID — IntegerUnsigned — Foreign key → ws_series.SERIES_ID — NOT NULL — Unique UQ_2, series System ID
- EPISODE_NAME — varchar(150) — NOT NULL — Unique UQ_2, episode name, unique in workspace
- EP_STATUS_GCD — varchar(24) — NOT NULL — indexing IDX_1, episode status, Refer refer USR-COM-VAL : EP_STATUS_GCD
- CREATION_TYPE — char(2) — NOT NULL — Episode creation type , Refer SYS-FIX-VAL : User Service-Episode creation type
- ORC_IMG_CNT — smallIntUnsigned — original image uploaded/bringed file count
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated by "user system id"
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — created by user system id
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
- IS_DONE_AUTO_TRANS — TINYINTunsigned — NOT NULL — done flag of auto translation feature , if 1 , user can't use auto translation
- IS_DONE_OCR — TINYINTunsigned — NOT NULL — done flag of ocr feature , if 1 , user can't use ocr
ws_episode_img
- IMG_ID — BIGINTUNSIGNED — Primary key — NOT NULL — image System ID,
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — indexing IDX_1, episode System ID,
- ORG_IMG_NAME — varchar(100) — NOT NULL — episode name, unique in workspace
- IMG_CATEGORY — char(1) — NOT NULL — episode image file category ( O: original file, E: edited imaged file)
- IMG_VER_NO (ORC_IMG_CNT) — smallIntUnsigned — NOT NULL — indexing IDX_1, Use the number of times uploaded as the version
- IMAGE_ORDER — smallIntUnsigned — NOT NULL — indexing IDX_1, image order number
- ORG_HEIGHT — smallIntUnsigned — NOT NULL — Height of the original image
- ORG_WITH — smallIntUnsigned — NOT NULL — Width of the original image
- O_IMG_URL — varchar(100) — NOT NULL — original image url
- P_IMG_URL — varchar(100) — NOT NULL — pc web image url
- M_IMG_URL — varchar(100) — NOT NULL — mobile image url
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — created by user system id
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- IS_DELETED — TINYINTunsigned — NOT NULL — deleted flag, 1 : deleted , it will be used on batch processing.
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_glossaries (update : 24.05.21) (ws_glossaries)
- GLOSSARY_ID — IntegerUnsigned — Primary key — NOT NULL — Glossaries system ID
- WS_ID — IntegerUnsigned — Foreign key → workspace ( update : 24.05.21).WS_ID — NOT NULL — Workspace System ID
- GLOSSARY_NAME — varchar(160) — NOT NULL — Unique UQ_1, glossaries name
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated id /created by "user system id"
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_glossary_org_terms
- ORG_TERM_ID (TERM_ID) — IntegerUnsigned — Primary key — NOT NULL — original term system id
- GLOSSARY_ID — IntegerUnsigned — Foreign key → ws_glossaries (update : 24.05.21).GLOSSARY_ID — NOT NULL — Glossaries system ID
- ORG_LANG — char(2) — NOT NULL — original language
- ORG_TERM — varch(60) — NOT NULL — original term
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated /created by "user system id"
- UPDATED_BY_ACCT — varchar(80) — NOT NULL — last updated /created by "account email"
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_glossary_target_terms
- TARG_TERM_ID — IntegerUnsigned — Primary key — NOT NULL — target term system id
- ORG_TERM_ID (TERM_ID2) — IntegerUnsigned — Foreign key → ws_glossary_org_terms.ORG_TERM_ID — NOT NULL — Unique UQ_1, original term system id
- TARGET_LANG — char(2) — NOT NULL — Unique UQ_1, target language
- TARGET_TERM — varchar(60) — NOT NULL — Unique UQ_1, target term
- UPDATED_BY_ID (Field2) — IntegerUnsigned — NOT NULL — last updated /created by "user system id"
- UPDATED_BY_ACCT — varchar(80) — NOT NULL — last updated /created by "account email"
- UPDATED_TM — DATETIME — NOT NULL
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_group (workspace_group)
- GROUP_ID — IntegerUnsigned — Primary key — NOT NULL — Private Workspace group System ID, , format is according ID rule
- GROUP_P_ID — char(14) — NOT NULL — Unique UQ_1, Public workspace group ID for external exposure ID, , format is according ID rule
- WS_ID — IntegerUnsigned — Foreign key → workspace ( update : 24.05.21).WS_ID — NOT NULL — Unique UQ_2, Private Workspace System ID, , format is according ID rule
- GROUP_NAME — varchar(40) — NOT NULL — Unique UQ_2, group name, unique in workspace
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — updated by "user system id"
- UPDATED_TM — DATETIME — NOT NULL — updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_group_account
- USER_ID — IntegerUnsigned — Primary key — NOT NULL — user system id
- GROUP_ID (GROUP_ID2) — IntegerUnsigned — Foreign key → ws_group.GROUP_ID — NOT NULL — ws group System ID,
- IS_MANGER — TINYINTunsigned — NOT NULL — group manger flag , 1 : manger
- ASSIGNED_BY_ID — Integer unsigned — NOT NULL — last assigned by "user system id"
- ASSIGNED_TM — DATETIME — NOT NULL — last assigned time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_member( include owner) (ws_member)
- USER_ID — IntegerUnsigned — Primary key — NOT NULL — user system id
- WS_ID — IntegerUnsigned — Foreign key → workspace ( update : 24.05.21).WS_ID — NOT NULL — Workspace System ID,
- WS_U_WORK_TYPE_GCD — varchar(24) — NOT NULL — workspace account category, Refer USR-COM-VAL: WS_U_WORK_TYPE_GCD
- ASSIGNED_BY_ID — IntegerUnsigned — NOT NULL — last assigned by "user system id"
- ASSIGNED_TM — DATETIME — NOT NULL — last assigned time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_ocr (update : 24.05.24) (ws_ocr_box)
- OCR_ID — BIGINTUNSIGNED — Primary key — NOT NULL — ID of the record (Auto Increment)
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — indexing IDX_1, Private episode System ID, , format is according ID rule
- TXT_ID — BIGINTUNSIGNED — Foreign key → ws_ep_text_box.TXT_ID — indexing IDX_1, Text System ID
- OCR_ENGINE_TYPE — TINYINTunsigned — NOT NULL — OCR Engine type , Refer SYS-FIX-VAL : System-OCR Engine
- COMBINED_X — int — NOT NULL — Combined X coordinate
- COMBINED_Y — int — NOT NULL — Combined Y coordinate
- WIDTH — int — NOT NULL — Width of the vision box
- HEIGHT — int — NOT NULL — Height of the vision box
- DOMINANT_COLOR — varchar(20) — Dominant color
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_pricing_plan (workspace_pricing_plan)
- PRICING_PLAN_ID — IntegerUnsigned — Primary key — NOT NULL — pricing plan system id
- APPLIED_DATE — DATETIME — Primary key — NOT NULL — pricing plan applied date time, UTC+0
- WS_ID — IntegerUnsigned — Foreign key → workspace ( update : 24.05.21).WS_ID — NOT NULL — Private Workspace System ID, , format is according ID rule
- END_DTTM — DATETIME — pricing plan end of date time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_series
- SERIES_ID — IntegerUnsigned — Primary key — NOT NULL — indexing IDX_1, Private series System ID, format is according ID rule
- SERIES_P_ID — varchar(14) — NOT NULL — Unique UQ_1, Public series ID for external exposure ID, , format is according ID rule
- GROUP_ID (GROUP_ID2) — IntegerUnsigned — Foreign key → ws_group.GROUP_ID — NOT NULL — Unique UQ_2, indexing IDX_1, Private Workspace System ID, , format is according ID rule
- SERIES_NAME — varchar(150) — NOT NULL — Unique UQ_2, series name, unique in workspace
- SERIES_TYPE — char(1) — NOT NULL — series type , refer SYS-FIX-VAL : User Service-Series type
- SERIES_STATUS — varchar(24) — NOT NULL — indexing IDX_1, series status, Refer refer SYS-FIX-VAL : User Service-Series Status
- ORIGI_LANG — varchar(6) — NOT NULL — Unique UQ_2, original language ( KO, EN.., EN-GB, EN-US)
- TRANS_LANG — varchar(6) — NOT NULL — Unique UQ_2,, translation language ( KO, EN.., EN-GB, EN-US)
- CREATION_TYPE — char(2) — NOT NULL — Episode creation type , only use UP/BR, Refer SYS-FIX-VAL : User Service-Episode creation type,
- THUMBNAIL_URL — varchar(100) — series thumbnail image url
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated by "user system id"
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_series_episode_member
- USER_ID — IntegerUnsigned — Primary key — NOT NULL — user system id
- SERIES_ID — IntegerUnsigned — Foreign key → ws_series.SERIES_ID — NOT NULL — ws series System ID
- EPISODE_ID — BIGINTUNSIGNED — Foreign key → ws_episode ( update : 24.05.21).EPISODE_ID — NOT NULL — episode System ID,
- ASSIGNED_BY_ID — IntegerUnsigned — NOT NULL — last assigned by "user system id"
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_series_leader
- USER_ID — IntegerUnsigned — Primary key — NOT NULL — user system id
- SERIES_ID — IntegerUnsigned — Foreign key → ws_series.SERIES_ID — NOT NULL — Private series System ID, , format is according ID rule
- ASSIGNED_BY_ID — IntegerUnsigned — NOT NULL — last assigned by "user system id"
- ASSIGNED_TM — DATETIME — NOT NULL — last assigned time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0
ws_series_setting
- SERIES_ID — IntegerUnsigned — Foreign key → ws_series.SERIES_ID — NOT NULL — ws series System ID,
- GLOSSARY_ID — IntegerUnsigned — Foreign key → ws_glossaries (update : 24.05.21).GLOSSARY_ID — NOT NULL — Glossary system ID
- TXT_BOX_SHAPE_TYPE — CHAR(1) — NOT NULL — Shape of the text box, Refer refer SYS-FIX-VAL : User Service-Text Box Shape
- FONT_FAMILY — varchar(30) — NOT NULL — Font family
- FONT_SIZE — SMALLINT — NOT NULL — font size
- TXT_BOX_DEF_BG_COLOR — varchar(20) — NOT NULL — text box default background color, ex : #FFFFFF
- TXT_DEF_FONT_STYLE_LIST — varchar(10) — text default font style, value list(B, I,U) , efer refer SYS-FIX-VAL : User Service-Font style , ex) [B,U]
- TXT_ALIGN — CHAR(1) — NOT NULL — Text alignment , refer SYS-FIX-VAL : User Service-Text Alignment
- UPDATED_BY_ID — IntegerUnsigned — NOT NULL — last updated by "user system id"
- CREATED_BY_ID — IntegerUnsigned — NOT NULL — created by user system id
- UPDATED_TM — DATETIME — NOT NULL — last updated time, UTC+0
- CREATED_TM — DATETIME — NOT NULL — created time, UTC+0