deeplearning
Tables (8)
announcements
- Announcements_id (announcements_id) — bigint — Primary key — NOT NULL
- Title (title) — varchar(200)
- Content (content) — longtext
- Created_at (created_at) — datetime
- Updated_at (updated_at) — datetime
- User_id (user_id) — int — Foreign key → auth_users.User_id — NOT NULL
auth_users
- User_id (user_id) — int — Primary key — NOT NULL
- ID (id) — varchar(150)
- PW (password) — varchar(255)
- last_login — datetime
- is_superuser — tinyint(1)
- is_staff — tinyint(1)
- is_active — tinyint(1)
- Date_joined (date_joined) — datetime
- Username (username) — varchar(150)
- First_name (first_name) — varchar(150)
- Last_name (last_name) — varchar(150)
- Email (email) — varchar(254)
clinical_record
- Record_id (record_id) — int — Primary key — NOT NULL
- Visit_date (visit_date) — dateime
- AJCC_PATHOLOGIC_TUMOR_STAGE (AJCC_Pathologic_Tumor_Stage) — String
- AJCC_TUMOR_PATHOLOGIC_PT — String
- AJCC_NODES_PATHOLOGIC_PN — String
- AJCC_METASTASIS_PATHOLOGIC_PM — String
- GRADE — String
- CHILD_PUGH_CLASSIFICATION — String
- AFP — float
- SERUM_ALBUMIN_PRERESECTION — float
- BILIRUBIN_TOTAL — float
- PROTHROMBIN_TIME_INR_AT_PROCUREMENT — float
- PLATELET_COUNT_PRERESECTION — float
- CREATININE_LEVEL_PRERESECTION — float
- ISHAK_FIBROSIS_SCORE — int
- DEFINITIVE_SURGICAL_PROCEDURE — String
- RESIDUAL_TUMOR — String
- FAMILY_HISTORY_OF_CANCER — String
- HISTORY_OTHER_MALIGNANCY — String
- HISTORY_HEPATO_CARCINOMA_RISK_FACTORS — String
- ECOG_SCORE — int
- TUMOR_STATUS — String
dbr_patients
- Patient_id (patient_id) — bigint — Primary key — NOT NULL
- Name (name) — varchar(100)
- Sex (sex) — enum('male', 'female')
- Age (age) — int
- Resident_Number (resident_number) — date
- Height (height) — decimal
- Weight (weight) — decimal
- Phone (phone) — varchar(11)
- Address (address) — varchar(255)
- Created_at (created_at) — datetime
- Updated_at (updated_at) — datetime
departments
- Department_id (department_id) — int — Primary key — NOT NULL
- Department_code (department_code) — varchar(10)
- department (departments) — varchar(50)
doctor_profile
- Doctor_id (doctor_id) — int — Primary key — NOT NULL
- Name (name) — varchar(150)
- Sex (sex) — enum('male', 'female')
- Phone (phone) — varchar(11)
- Email (email) — varchar(254)
- Status (status) — enum('on_duty', 'available', 'off_duty')
- is_staff — tinyint(1)
- Position (position) — varchar(50)
- Created_at (created_at) — datetime
- Updated_at (updated_at) — datetime
- Department_id (department_id) — int — Foreign key → departments.Department_id — NOT NULL
- User_id (user_id) — int — Foreign key → auth_users.User_id — NOT NULL
genomic_record
- Sample_id (sample_id) — int — Primary key — NOT NULL
- GPR182 — float
- KLRB1 — float
- SPOCD1 — float
medical_record
- Record_id (record_id) — int — Primary key — NOT NULL
- Visit_date (visit_date) — dateime
- Chief_complatint (chief_complatint) — varchar(255)
- Subjective_note (subjective_note) — text
- Objective_note (objective_note) — text
- assessment — text
- Plan (plan) — text
- Prescription (prescription) — text