COURSE ERD

Tables (5)

con_tc_t (Untitled)

  • tc_nm — varchar(50)
  • tc_stnm — varchar(100)
  • tc_st_poi_mid — int(4)
  • tc_ednm — varchar(100)
  • poi_mid — int(4)
  • tc_id — varchar(50)

con_ts_t

  • ts_nm — varchar(50)
  • ts_stnm — varchar(100)
  • ts_st_poi_mid — int(4)
  • ts_ednm — varchar(100)
  • poi_mid — int(4)

poi_dp_p (Untitled3)

  • poi_mid — int(4) — Primary key — NOT NULL
  • c_id

poi_dp_p_rel (Untitled4)

  • Field

ref_geo_p (Untitled2)

  • g_nm
  • tc_id — varchar(50)