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