gasang giiup
Tables (5)
BACKUP_DB (Untitled6)
- Key — Primary key — NOT NULL
BOOK_ORDER_DB (Untitled4)
- order_id (Key) — INT (PK) — Primary key — NOT NULL
- user_id (Field) — INT (FK -> user_id)
- book_title (Field2) — VARCHAR(200)
- price (Field3) — INT
- approve_by (Field4) — INT(FK -> staff_id
- order_date (Field5) — DATE
LMS_LOG_DB (Untitled2)
- log_id (Key) — INT(PK) — Primary key — NOT NULL
- user_id (Field2) — INT(FK -> user_id)
- action (Field3) — TEXT
- timestamp (Field4) — DATETIME
STAFF_MGMT_DB (Untitled3)
- staff_id (Key) — INT(PK) — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- position (Field2) — VARCHAR(100)
- asset_tag (Field3) — VARCHAR(50)
USER_DB (Untitled)
- user_id (Key) — INT(PK) — Primary key — NOT NULL
- name — VARCHAR(100)
- email (Field) — VARCHAR(100)
- enroll_date (Field2) — DATE