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