00

Tables (5)

TB_DISTRIBUTION (Untitled3)

  • qr_idx — int(11) — Foreign key → TB_QR.qr_idx — NOT NULL
  • user_idx — int(11) — Foreign key → TB_USER.user_idx — NOT NULL
  • f_idx — int(11)
  • f_out_dt — datetime
  • f_out_temp — float
  • w_idx — int(11)
  • w_in_dt — datetime
  • w_out_dt — datetime
  • w_in_temp — float
  • w_out_temp — float
  • s_idx — int(11)
  • s_in_dt — datetime
  • s_out_dt — datetime
  • s_in_temp — float
  • s_out_temp
  • c_idx — int(11)
  • c_in_dt — datetime
  • c_in_temp — float

TB_INJECTION_LIST (Untitled2)

  • user_idx — int(11) — Foreign key → TB_USER.user_idx — NOT NULL
  • vaccine_idx — int(11) — Foreign key → TB_VACCINE.vaccine_idx — NOT NULL

TB_QR (Untitled5)

  • qr_idx — int(11) — Primary key — NOT NULL
  • qr_code — varchar(250)

TB_USER (Untitled)

  • user_idx — int(11) — Primary key — NOT NULL
  • user_type — enum('F', 'W', 'C', 'P', 'S')
  • user_id — varchar(50)
  • user_pw — varchar(250)
  • name — varchar(50)
  • age — int(3)
  • location — varchar(50)
  • underlying — enum('Y', 'N')
  • infection — enum('Y', 'N')
  • city — varchar(50)

TB_VACCINE (Untitled4)

  • vaccine_idx — int(11) — Primary key — NOT NULL
  • qr_idx — int(11) — Foreign key → TB_QR.qr_idx — NOT NULL
  • brand — varchar(20)
  • prod_dt — datetime
  • exp_dt — datetime
  • moderate_temp — float
  • cautions — text