doc
Tables (17)
ADMINS
- id — INT — Primary key — NOT NULL
- admin_account — VARCHAR(255) — NOT NULL
- admin_password — VARCHAR(255)
- created_at — TIMESTAMP
ADMIN_SESSIONS
- id — INT — Primary key — NOT NULL
- admin_id — INT — NOT NULL
- session_value — VARCHAR(128) — NOT NULL
- created_at — TIMESTAMP
- last_access_at — TIMESTAMP
- expires_at — TIMESTAMP
- ip_address — VARCHAR(45)
- user_agent — TEXT
- is_active — BOOLEAN
AUDIT_LOG
- id — INT
- action_type — VARCHAR(255) — NOT NULL
- entity_type — INT — NOT NULL
- user_name — VARCHAR(255)
- description — VARCHAR(255) — NOT NULL
- timestamp — TIMESTAMP — NOT NULL
- ip_address — VARCHAR(255)
- sucess — BOOLEAN
COMMENTS
- id — INT — Primary key — NOT NULL
- doc_id — INT — NOT NULL
- part_id — INT — NOT NULL
- id2 — INT — NOT NULL
- body — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- Field — BOOLEAN — NOT NULL
CUSTOMERS
- id — INT — Primary key — NOT NULL
- customer_name — VARCHAR(255) — NOT NULL
- rep_name — VARCHAR(50) — NOT NULL
- reg_num — VARCHAR(50) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- main_num — VARCHAR(50)
- fax_num — VARCHAR(50)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CopyOfPARTICIPANTS
- id — INT — Primary key — NOT NULL
- doc_id — INT — NOT NULL
- user_id — INT — NOT NULL
- state — ENUM — NOT NULL
DOC_TRX
- id — INT — Primary key — NOT NULL
- template_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- user_id — INT — NOT NULL
- partner_id — INT
- doc_num — VARCHAR(50) — NOT NULL
- published — DATE
- exchange_rate — DECIMAL
- total_amount — DECIMAL(12,2)
- total_vat — DECIMAL(12,2)
- total — DECIMAL(12,2)
- prev_outstanding — DECIMAL(12,2)
- current_payment — DECIMAL(12,2)
- outstanding_balance — DECIMAL(12,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- title — VARCHAR(100)
- state — ENUM — NOT NULL
FILES
- id — INT — Primary key — NOT NULL
- part_id — INT — NOT NULL
- commetn_id — INT — NOT NULL
- filename — VARCHAR(50) — NOT NULL
- stored_name — VARHCAR(255) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(255) — NOT NULL
- size_bytes — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
PARTICIPANTS
- id — INT — Primary key — NOT NULL
- doc_id — INT — NOT NULL
- user_id — INT — NOT NULL
PARTNERS
- id — INT — Primary key — NOT NULL
- customer_id — INT — NOT NULL
- partner_name — VARCHAR(255) — NOT NULL
- depart — VARCHAR(255) — NOT NULL
- position — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- mobile_num — VARCHAR(50)
- direct_num — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
PRODUCTS
- id — INT — Primary key — NOT NULL
- main_category — VARCHAR(50)
- sub_category — VARCHAR(50)
- product_name — VARCHAR(50) — NOT NULL
- specification — TEXT — NOT NULL
- unit_price — DECIMAL — NOT NULL
- note — TEXT
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
SESSIONS
- id — INT — Primary key — NOT NULL
- user_id — INT
- session_value — VARCHAR(128) — NOT NULL
- created_at — TIMESTAMP
- last_access_at — TIMESTAMP
- timeout — int
- expires_at — TIMESTAMP
- ip_address — VARCHAR(45)
- user_agent — TEXT
- is_active — BOOLEAN
SYSTEM_SETTINGS
- id — INT — Primary key — NOT NULL
- setting_key — VARCHAR(255)
- value — VARCHAR(255)
TEMPLATES
- id — INT — Primary key — NOT NULL
- template_name — VARCHAR(50)
- schema — TEXT
- rule — TEXT
TRX_ITEMS
- id — INT — Primary key — NOT NULL
- doc_id — INT
- product_id — INT
- product_name — VARCHAR(50)
- specification — TEXT
- unit_price — DECIMAL(12,2)
- quantity — INT — NOT NULL
- amount — DECIMAL(12,2)
- vat — DECIMAL(12,2)
- note — TEXT
USERS
- id — INT — Primary key — NOT NULL
- user_account — VARCHAR(255) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- depart — VARCHAR(50)
- position — VARCHAR(50)
- mobile_num — VARCHAR(50)
- direct_num — VARCHAR(50)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- last_login_at — TIMESTAMP
- is_password_set — BOOLEAN
USER_INVITES
- id — INT — Primary key — NOT NULL
- user_id — INT
- url — VARCHAR(255)
- sent_at — TIMESTAMP
- check_value — VARCHAR(255)