core_project
Tables (9)
domestic_trips
- region — VARCHAR2(50)
- count — NUMBER(18, 0)
regionaltourismgrowth
- region — VARCHAR2(50)
- tourismgrowthrate — NUMBER(5,2)
sa_ranking
- sa_name — VARCHAR2(50) — Foreign key → tb_service_area.sa_name — NOT NULL
- base_ym — VARCHAR2(10)
- os_ranking — NUMBER
- sa_sr — NUMBER
- sa_code — VARCHAR2(10)
- store_code — NUMBER
- store_name — VARCHAR2(100)
- monthly_sales — NUMBER
tb_admin
- admin_id — VARCHAR2(30) — Primary key — NOT NULL
- sa_name — VARCHAR2(50) — Foreign key → tb_service_area.sa_name — NOT NULL
- admin_pw — VARCHAR2(255)
- admin_tel — VARCHAR2(20)
- sa_addr — VARCHAR2(255)
- admin_position — VARCHAR2(20)
tb_details
- sa_name — VARCHAR2(50) — Foreign key → tb_service_area.sa_name — NOT NULL
- parking_space — NUMBER(8,0)
- is_car_maintenance — CHAR(1) — NOT NULL
- is_gas_station — CHAR(1) — NOT NULL
- is_lpg_station — CHAR(1) — NOT NULL
- is_ev_charge — CHAR(1) — NOT NULL
- is_break_room — CHAR(1) — NOT NULL
- is_rest_room — CHAR(1) — NOT NULL
- is_drug_store — CHAR(1) — NOT NULL
- is_nursing_room — CHAR(1) — NOT NULL
- is_snack_bar — CHAR(1) — NOT NULL
- is_restaurant — CHAR(1) — NOT NULL
- is_hydrogen_charge — CHAR(1) — NOT NULL
- created_at — DATE — NOT NULL
tb_service_area
- sa_name — VARCHAR2(50) — Primary key — NOT NULL
- sa_type — VARCHAR2(50) — NOT NULL
- sa_addr — VARCHAR2(1000) — NOT NULL
- lat — NUMBER(17, 14) — NOT NULL
- lon — NUMBER(17, 14) — NOT NULL
- sa_img1 — VARCHAR2(1000)
- sa_img2 — VARCHAR2(1000)
- sa_img3 — VARCHAR2(1000)
- created_at — DATE
- updated_at — DATE
tb_service_video
- sa_name — VARCHAR2(50) — Foreign key → tb_service_area.sa_name — NOT NULL
- video_link — VARCHAR2(500)
tb_suggestion
- suggestion_idx — NUMBER(10,0) — Primary key — NOT NULL
- sa_name — VARCHAR2(50) — Foreign key → tb_service_area.sa_name — NOT NULL
- suggestion_title — VARCHAR2(50)
- suggestion_content — VARCHAR2(1000)
- suggestion_publisher — VARCHAR2(20)
- create_at — DATE
tourismstats
- referencemonth — VARCHAR2(6)
- visitorcount — NUMBER(10,1)
- visitorcountlastyear — NUMBER(10,1)
- visitorcountgrowthrate — NUMBER(5,2)
- tourismexpenditure — NUMBER(10,1)
- tourismexpenditurelastyear — NUMBER(10,1)
- tourismexpendituregrowthrate — NUMBER(5,2)