chaplin

Tables (9)

bot_pla_tb

  • pla_sq — int — Primary key — NOT NULL
  • pla_nm — varchar(50) — NOT NULL
  • pla_ad — varchar(50) — NOT NULL

bot_ptag_tb

  • ptag_sq — int — Primary key — NOT NULL
  • tag_sq — int — Foreign key → bot_tag_tb.tag_sq — NOT NULL
  • pla_sq (pla_sq2) — int — Foreign key → bot_pla_tb.pla_sq — NOT NULL

bot_tag_tb

  • tag_sq — int — Primary key — NOT NULL
  • tag_con — varchar(50) — NOT NULL

fes_tb

  • fes_sq — int — Primary key — NOT NULL
  • met_sq — int — Foreign key → map_met_tb.met_sq — NOT NULL
  • fes_nm — varchar(50) — NOT NULL
  • fes_s_dd — date — NOT NULL
  • fes_f_dd — date — NOT NULL
  • fes_hh — varchar(50)
  • fes_ad — varchar(100) — NOT NULL
  • fes_char — varchar(100)
  • fes_ex — varchar(255) — NOT NULL

map_city_tb

  • city_sq — int — Primary key — NOT NULL
  • met_sq — int — Foreign key → map_met_tb.met_sq
  • city_k_nm — varchar(20) — NOT NULL
  • city_e_nm — varchar(30) — NOT NULL

map_met_tb

  • met_sq — int — Primary key — NOT NULL
  • met_k_nm — varchar(20) — NOT NULL
  • met_e_nm — varchar(20) — NOT NULL

pln_des_tb

  • des_sq — int — Primary key — NOT NULL
  • met_sq — int — Foreign key → map_met_tb.met_sq
  • city_sq — int — Foreign key → map_city_tb.city_sq
  • pln_sq — int — Foreign key → pln_inf_tb.앞이논리 — NOT NULL
  • des_dd — int — NOT NULL
  • des_no — int — NOT NULL
  • des_lat — decimal(13,10) — NOT NULL
  • des_long — decimal(13,10) — NOT NULL
  • des_nm — varchar(50) — NOT NULL

pln_inf_tb

  • 앞이논리 (pln_sq) — int — Primary key — NOT NULL
  • usr_sq — varchar(20) — Foreign key → usr_tb.usr_sq — NOT NULL
  • met_sq — int — Foreign key → map_met_tb.met_sq
  • city_sq — int — Foreign key → map_city_tb.city_sq
  • pln_nm — varchar(20)
  • pln_s_dd — date — NOT NULL
  • pln_f_dd — date — NOT NULL
  • pln_reg_dt — timestamp — NOT NULL
  • pln_mod_dt — timestamp — NOT NULL

usr_tb

  • usr_sq — varchar(45) — Primary key — NOT NULL
  • usr_id — varchar(20) — NOT NULL
  • usr_pw — varchar(50) — NOT NULL
  • usr_nm — varchar(20) — NOT NULL
  • usr_gn — varchar(2) — NOT NULL
  • usr_em — varchar(45) — NOT NULL
  • usr_reg_dt — timestamp — NOT NULL
  • usr_mod_dt — timestamp