soundly

Tables (9)

soundly_cate (Untitled2)

  • cate_idx (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — ""
  • status_flag (Field2) — ""
  • del_flag (Field3) — ""
  • reg_date (Field4) — YYYY-MM-DD

soundly_city (Untitled8)

  • city_idx (Key) — NOT NULL — Primary key — NOT NULL
  • state_idx (Key2) — NOT NULL — Foreign key → soundly_state.state_idx — NOT NULL
  • name (Field) — ""
  • status_flag (Field2) — ""
  • del_flag (Field3) — ""
  • reg_date (Field4) — YYYY-MM-DD

soundly_company

  • company_idx (int(11)) — NOT NULL — Primary key — NOT NULL — company 연번
  • name (NOT NULL) — ""
  • status_flag (Field) — ""
  • del_flag (Field2) — ""
  • reg_date (Field3)

soundly_freq (Untitled6)

  • freq_idx (Key) — NOT NULL — Primary key — NOT NULL
  • generator_idx (Key2) — NOT NULL — Foreign key → soundly_generator.generator_idx — NOT NULL
  • status_flag (Field) — ""
  • del_flag (Field2) — ""

soundly_generator (Untitled4)

  • generator_idx (Key) — NOT NULL — Primary key — NOT NULL
  • sid (Field2) — NOT NULL
  • generator_sid (Field10) — ""
  • audio_type (Field) — NOT NULL
  • cate_idx (Key2) — NOT NULL — Foreign key → soundly_cate.cate_idx — NOT NULL
  • sub_cate_idx (Key3) — NOT NULL — Foreign key → soundly_sub_cate.sub_cate_idx — NOT NULL
  • company_idx (int(11)) — NOT NULL — Foreign key → soundly_company.company_idx — NOT NULL — company 연번
  • sub_company_idx (Key4) — NOT NULL — Foreign key → soundy_sub_company.sub_company_idx — NOT NULL
  • state_idx (Key5) — NOT NULL — Foreign key → soundly_state.state_idx — NOT NULL
  • city_idx (Key6) — NOT NULL — Foreign key → soundly_city.city_idx — NOT NULL
  • frequency (Field3) — ""
  • place (Field12) — ""
  • noise_lvl (Field4) — ""
  • file_path (Field11) — ""
  • start_date (Field5) — YYYY-MM-DD
  • end_date (Field6) — YYYY-MM-DD
  • status_flag (Field7) — ""
  • del_flag (Field8) — ""
  • reg_date (Field9) — YYYY-MM-DD

soundly_reception (Untitled5)

  • reception_idx (Key) — NOT NULL — Primary key — NOT NULL
  • sid (Field) — NOT NULL
  • adid (Field2) — ""
  • logtime (Field3) — YYYY-MM-DD

soundly_state (Untitled7)

  • state_idx (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — ""
  • status_flag (Field2) — ""
  • del_flag (Field3) — ""
  • reg_date (Field4) — YYYY-MM-DD

soundly_sub_cate (Untitled3)

  • sub_cate_idx (Key) — NOT NULL — Primary key — NOT NULL
  • cate_idx (Key2) — NOT NULL — Foreign key → soundly_cate.cate_idx — NOT NULL
  • name (Field) — ""
  • status_flag (Field2) — ""
  • del_flag (Field3) — ""
  • Field4 — YYYY-MM-DD

soundy_sub_company (Untitled)

  • sub_company_idx (Key) — NOT NULL — Primary key — NOT NULL
  • company_idx (int(11)) — NOT NULL — Foreign key → soundly_company.company_idx — NOT NULL — company 연번
  • name (Field) — ""
  • description (Field2) — ""
  • status_flag (Field3) — ""
  • del_flag (Field4) — ""
  • reg_date (Field5) — YYYY-MM-DD