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