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