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