육아일기_snowflake_ERD

테이블 (5)

ACCOMMODATION_FACILITIES (숙박업소 시설)

  • ACCOMMODATION_ID (Key) — NUMBER(38,0) — 외래 키 → ACCOMMODATION_TABLE.ACCOMMODATION_ID — NOT NULL
  • ACCOMMODATION_MAINCATEGORY (숙박업소 메인카테고리) — VARCHAR(30)
  • ACCOMMODATION_FACILITIES (시설) — VARCHAR(200)
  • LOAD_TIMESTAMP (날짜) — DATE

ACCOMMODATION_LOCATION (숙박업소 지역)

  • ACCOMMODATION_ID (Key) — NUMBER(38,0) — 외래 키 → ACCOMMODATION_TABLE.ACCOMMODATION_ID — NOT NULL
  • ACCOMMODATION_LOCATION_MAJOR (시/도 단위) — VARCHAR(30)
  • ACCOMMODATION_LOCATION_MIDDLE (구 단위) — VARCHAR(30)
  • ACCOMMODATION_LOCATION_SUB (동 단위) — VARCHAR(30)
  • ACCOMMODATION_LOCATION_DETAIL (상세주소) — VARCHAR(100)
  • LOAD_TIMESTAMP (날짜) — DATE

ACCOMMODATION_PRICE (숙박업소 가격)

  • ACCOMMODATION_ID (Key) — NUMBER(38,0) — 외래 키 → ACCOMMODATION_TABLE.ACCOMMODATION_ID — NOT NULL
  • DATE_TYPE (주/야) — VARCHAR(20)
  • PRICE (가격) — NUMBER(38,0)
  • LOAD_TIMESTAMP (날짜) — DATE

ACCOMMODATION_REVIEW (숙박업소 리뷰)

  • ACCOMMODATION_ID (Key) — NUMBER(38,0) — 외래 키 → ACCOMMODATION_TABLE.ACCOMMODATION_ID — NOT NULL
  • ACCOMMODATION_RATING (리뷰점수) — FLOAT
  • ACCOMMODATION_REVIEWCOUNT (리뷰갯수) — NUMBER(38,0)
  • LOAD_TIMESTAMP (날짜) — DATE

ACCOMMODATION_TABLE (숙박업소 테이블)

  • ACCOMMODATION_ID (Key) — NUMBER(38,0) — 기본 키 — NOT NULL
  • ACCOMMODATION_NAME (숙박업소 이름) — VARCHAR(100)
  • ACCOMMODATION_MAINCATEGORY (숙박업소 메인카테고리) — VARCHAR(30)
  • ACCOMMODATION_SUBCATEGORY (숙박업소 서브카테고리) — VARCHAR(30
  • LOAD_TIMESTAMP (날짜) — DATE