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