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