Dược

Tables (9)

Attach (Tep Dinh Kem)

  • ID (Ma Tep Dinh Kem) — String [10] — Primary key — NOT NULL
  • Name (Ten Tep Dinh Kem) — String [60]
  • OrderID (Ma Don Hang) — String [16] — Foreign key → Order.OrderID — NOT NULL

Company (Doanh Nghiep)

  • MST (Ma So Thue) — String [10] — Primary key — NOT NULL
  • Name (Ten Doanh Nghiep) — String [50]
  • Address (Dia Chi) — String [50]
  • SDT (So Dien Thoai) — String [10]
  • Representative (Dai Dien Doanh Nghiep) — String [50]
  • Level (Chuc Vu) — String [20]

Document (Cong Van)

  • ID (Ma Cong Van) — String [10] — Primary key — NOT NULL
  • DocNo (So Cong Van) — String [20]
  • Content (Noi Dung Cong Van) — Text
  • CreateDate (Ngay Ban Hanh) — Date
  • OrderID (Ma Don Hang) — String [16] — Foreign key → Order.OrderID — NOT NULL

Medicine (Duoc Lieu)

  • ID (Ma Duoc Lieu) — String [10] — Primary key — NOT NULL
  • Name (Ten Duoc Lieu) — String [30]
  • Origin (Nguon Goc) — String [50]
  • Quantity (So Luong) — Integer
  • Unit (Don Vi Tinh) — String [10]
  • Type (Hinh Thuc Dong Goi) — String [30]
  • Departure (Noi Gui) — String [30]
  • Destination (Noi nhan) — String [30]
  • Transportation (Hinh Thuc Van Chuyen) — String [50]

Order (Don Hang)

  • OrderID (Ma Don Hang) — String [16] — Primary key — NOT NULL
  • CreateDate (Ngay Tao Don) — Date
  • LicenseDate (Ngay Cap Phep) — Date — NOT NULL
  • Status (Trang Thau) — String [20]
  • MST (Ma So Thue) — String [10] — Foreign key → Company.MST — NOT NULL

User (Nguoi Dung)

  • ID (Ma Nguoi Dung) — String [10] — Primary key — NOT NULL
  • Name (Ho Va Ten) — String [50]
  • Role (Vai Tro) — String [20]
  • Birthday (Ngay Sinh) — Date — NOT NULL
  • Gender (Gioi Tinh) — String [5] — NOT NULL

order_medicine

  • ID (Ma Duoc Lieu) — String [10] — Foreign key → Medicine.ID — NOT NULL
  • OrderID (Ma Don Hang) — String [16] — Foreign key → Order.OrderID — NOT NULL

user_document

  • ID (Ma Cong Van) — String [10] — Foreign key → Document.ID — NOT NULL
  • ID (Ma Nguoi Dung) — String [10] — Foreign key → User.ID — NOT NULL

user_order

  • OrderID (Ma Don Hang) — String [16] — Foreign key → Order.OrderID — NOT NULL
  • ID (Ma Nguoi Dung) — String [10] — Foreign key → User.ID — NOT NULL