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)