육아일기_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