Skip to Content

Globale Data Structure And Models Diagram

Last modified by Kerem Yollu on 2025/03/21 15:34

Data Structure

Component

This is to be take as a component of any kind not only electronics. 

LEGEND
[Not supported by viewer]
PROJECT_ITEMS
PROJECT_ITEMS
SUPPLIER
SUPPLIER
PROJECT
PROJECT
ITEM
ITEM
TODO
TODO
TASK
TASK
Pricing Data
Pricing Data
OFFERT
OFFERT
Allow Groupe
Allow Groupe
COMMENT
COMMENT
COMPANY
COMPANY
ADDRESS
ADDRESS
UID
UID
TYPE
TYPE
RELATION
RELATION
STATUS
STATUS
Name
Name
Description
Description
Timestamps
Timestamps
TASK
TASK
TODO
TODO
LEGAL FORM
LEGAL FORM
#PARENT_COMPANY
#PARENT_COMPANY
#CHILD_COMPANY
#CHILD_COMPANY
COMMENT
COMMENT
PROJECT
PROJECT
UID
UID
PARTIES
PARTIES
Description
Description
Name
Name
Project Dates
Project Dates
Project Quantities
Project Quantities
RESPONSIBLES
RESPONSIBLES
TASK
TASK
TODO
TODO
Timestamps
Timestamps
#SUB_PROJECT
#SUB_PROJECT
#PARENT_PROJECT
#PARENT_PROJECT
TYPE
TYPE
ITEMS
ITEMS
AREA
AREA
MILESTONES
MILESTONES
Pricing Data
Pricing Data
OFFERT
OFFERT
    Reachable from extern interface, users, or on time users. to see advancement and conditions
[Not supported by viewer]
USER (intern responsable)
USER (intern responsable)
COMMENT
COMMENT
STOCK
STOCK
ADDRESS
ADDRESS
UID
UID
ITEM
ITEM
GEOGRAPHY
GEOGRAPHY
Country
Country
Region
Region
Postal code
Postal code
Dsitrict
Dsitrict
COMPANY_TYPES
COMPANY_TYPES
Timestamps
Timestamps
Description
Description
Name
Name
UID
UID
COMPANY_RELATION
COMPANY_RELATION
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PERSON
PERSON
UID
UID
ADDRESS
ADDRESS
RELATION
RELATION
Timestamps
Timestamps
Name
Name
Surname
Surname
Title
Title
Description
Description
Date of birth
Date of birth
Tel nos
Tel nos
Emails
Emails
PERSONEL_ROLES
PERSONEL_ROLES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
EMPLOYEE
EMPLOYEE
PERSON
PERSON
UID
UID
Start Date
Start Date
ROLE
ROLE
COMPANY
COMPANY
TODO
TODO
TASK
TASK
Timestamps
Timestamps
Description
Description
COMMENT
COMMENT
COMPANY_LEGAL_FORM
COMPANY_LEGAL_FORM
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
COMPANY_STATUS
COMPANY_STATUS
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PROJECT_COMPANIES
PROJECT_COMPANIES
COMPANY
COMPANY
REPONSABILITY
REPONSABILITY
PROJECT
PROJECT
TODO
TODO
TASK
TASK
PROJECT_COMPANIES_ROLES
PROJECT_COMPANIES_ROLES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PROJECT_RESPONSIBLE
PROJECT_RESPONSIBLE
EMPLOYEE
EMPLOYEE
REPONSABILITY
REPONSABILITY
PROJECT
PROJECT
TODO
TODO
TASK
TASK
PROJECT_PERSON_ROLES
PROJECT_PERSON_ROLES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
ITEM
ITEM
UID
UID
MANUFACTURER
MANUFACTURER
Name
Name
Description
Description
ITEM_GROUPE
ITEM_GROUPE
CATEGORY
CATEGORY
TODO
TODO
TASK
TASK
Item Dates
Item Dates
DATA
DATA
Price
Price
COMMENT
COMMENT
    Items can also be services
<div>&nbsp;&nbsp;&nbsp; Items can also be services<br></div>
Art-no-Intern
Art-no-Intern
Article_No_Man
Article_No_Man
ITEM_CATEGORY
ITEM_CATEGORY
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
#SUB_CATEGORY
#SUB_CATEGORY
#PARENT_CATEGORY
#PARENT_CATEGORY
ITEM_DATA
ITEM_DATA
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
Data_Blob
Data_Blob
TODO
TODO
TASK
TASK
DATA
DATA
CLASSIFICATION
CLASSIFICATION
COMMENT
COMMENT
ITEM_DATA_TYPE
ITEM_DATA_TYPE
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
Data_Blob
Data_Blob
PROJECT_TYPES
PROJECT_TYPES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PROJECT_AREAS
PROJECT_AREAS
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PROJECT_MILESTONES
PROJECT_MILESTONES
MILESTONE
MILESTONE
PROJECT
PROJECT
TODO
TODO
TASK
TASK
Name
Name
Description
Description
Allow Pricing
Allow Pricing
OFFERT
OFFERT
Timeline
Timeline
COMMENTS
COMMENTS
OFFERT
OFFERT
UID
UID
DEBITOR
DEBITOR
Name
Name
Description
Description
CREDITOR
CREDITOR
TODO
TODO
TASK
TASK
Offert Dates
Offert Dates
STATUS
STATUS
    Reachable from extern interface, users, or on time users. to see and validate or jeject offert, or offert positions
[Not supported by viewer]
COMMENTS
COMMENTS
PRICE
PRICE
ITEM_GROUPE
ITEM_GROUPE
UID
UID
No
No
Description
Description
Timestamps
Timestamps
TODO
TODO
TASK
TASK
ITEM
ITEM
CATEGORY
CATEGORY
COMMENT
COMMENT
MILESTONE
MILESTONE
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
TYPE
TYPE
MILESTONE_TYPE
MILESTONE_TYPE
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
PRICE
PRICE
UID
UID
Amount
Amount
Valid Until
Valid Until
Timestamps
Timestamps
TYPE
TYPE
PRICING_SCHEME
PRICING_SCHEME
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
OFFERT_STATUS
OFFERT_STATUS
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
API OUT
API IN
[Not supported by viewer]
API OUT
API IN
EXAMPLE LINK
[Not supported by viewer]
INVOIGING
INVOIGING
UID
UID
DEBITOR
DEBITOR
Name
Name
Description
Description
CREDITOR
CREDITOR
TODO
TODO
TASK
TASK
Offert Dates
Offert Dates
STATUS
STATUS
    Reachable from extern interface, users, or on time users. to see and validate or jeject offert, or offert positions
[Not supported by viewer]
COMMENTS
COMMENTS
POSITION
POSITION
STOCK_ITEMS
STOCK_ITEMS
TYPE
TYPE
POSITION
POSITION
Quantity
Quantity
USER(who put it there)
USER(who put it there)
Quantity measurment
Quantity measurment
Status measurment
Status measurment
Quality Measurments
Quality Measurments
STOCK_POSITIONS
STOCK_POSITIONS
UID
UID
#PARENT_POSITION
#PARENT_POSITION
#SUB_POSITION
#SUB_POSITION
Coordinates
Coordinates
PERSON_RELATION
PERSON_RELATION
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
USER
USER
ADDRESS
ADDRESS
TYPE
TYPE
Timestamps
Timestamps
Name
Name
Surname
Surname
Title
Title
Description
Description
Date of birth
Date of birth
Tel nos
Tel nos
Emails
Emails
Password
Password
UID
UID
USER_TYPES
USER_TYPES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
      For Example I want to allows external user to being able to axxess some parts like Thier projects advancmenet (but not pticing shcemes). Ther are also one time users, and of course internal users
[Not supported by viewer]
API OUT
API IN
Example Link
[Not supported by viewer]
WEB HOOKS FOR IOT DEVICES
WEB HOOKS FOR IOT DEVICES
DATA COLLECTION (To save place)
DATA COLLECTION (To save place)
STANDARD TABLES
STANDARD TABLES
RELATIONS
RELATIONS
RECURRING TABLES
RECURRING TABLES
# LINKS TO IT'S SELF
ex: one project may have as many sub-projects as desired
<div># LINKS TO IT'S SELF</div><div>ex: one project may have as many sub-projects as desired<br></div>
TODO
TODO
UID
UID
Timestamps
Timestamps
Due Date
Due Date
Start Date
Start Date
Description
Description
Title
Title
URGENCY
URGENCY
STATUS
STATUS
Type (generated from where)
Type (generated from where)
USER(Creator Of todo)
USER(Creator Of todo)
    Can the Todo track from which table it was created -> TYPE (Project, Item, Company, etc) ?
it's private to the USER 
[Not supported by viewer]
FLAGS
FLAGS
DATA
DATA
AUTOMATED DATA
ex time stamps (created updated modified)
<div>AUTOMATED DATA <br></div><div>ex time stamps (created updated modified)<br></div>
TODO_STATUS
TODO_STATUS
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
TODO_URGENCIES
TODO_URGENCIES
UID
UID
Name
Name
Description
Description
Timestamps
Timestamps
 
[Not supported by viewer]
API OUT
API IN
[Not supported by viewer]
TASK
TASK
UID
UID
Timestamps
Timestamps
Due Date
Due Date
Start Date
Start Date
Description
Description
Title
Title
URGENCY
URGENCY
STATUS
STATUS
Type (generated from where)
Type (generated from where)
    Can the TASK track from which table it was created -> TYPE (Project, Item, Company, etc) ?
Be assigned to the USER, Automatically ?
[Not supported by viewer]
USER(Creator)
USER(Creator)
USER (Assigned)
USER (Assigned)
COMMENT
COMMENT
COMMENT
COMMENT
UID
UID
Timestamps
Timestamps
Content
Content
Title
Title
Type (generated from where)
Type (generated from where)
    Can the COMMENTS track from which table it was created -> TYPE (Project, Item, Company, etc) ?
COMMENTS are only INTER and can NEVER BE seen by EXTERN USER
[Not supported by viewer]
USER(Creator)
USER(Creator)
#SUB_COMMENT
#SUB_COMMENT
#PARENT_COMMENT
#PARENT_COMMENT
 
[Not supported by viewer]
 
[Not supported by viewer]
API OUT
API IN
[Not supported by viewer]
API OUT
API IN
[Not supported by viewer]
Example Window For A PROJECT
Example Window For A PROJECT
PROJECT DETAILS
PROJECT DETAILS
SUB PROJECTS / PARENT PROJECTS
SUB PROJECTS / PARENT PROJECTS
PROJEC TITEMS
PROJEC TITEMS
POS
POS
ART-NO
ART-NO
DESCRIPTION
DESCRIPTION
PARTIES
PARTIES
REPONSIBLES
REPONSIBLES
DATES
DATES
QUANTITIES
QUANTITIES
MILESTONES
MILESTONES
TASKS
"SIMILAR TO PROJECT ITEMS"
<div>TASKS</div><div>"SIMILAR TO PROJECT ITEMS"<br></div>
COMMENTS
"SIMILAR TO PROJECT ITEMS"
<div>COMMENTS</div><div>"SIMILAR TO PROJECT ITEMS"</div>
MANUFACTURER
MANUFACTURER
TODOS
TODOS
TASK
TASK
MAN. NO
MAN. NO
PRICE
PRICE
OFFERT NO
OFFERT NO
VALID TILL
VALID TILL
OFFERT STATUS
OFFERT STATUS
ITEM STATUS
ITEM STATUS
DESCRIPTION
DESCRIPTION
GENERAL INFORMATION (Type industry, etc)
GENERAL INFORMATION (Type industry, etc)
SEARCH FILED
SEARCH FILED
Diagram