캡디
테이블 (18)
cafe
- id — SERIAL
- category — VARCHAR(255)
- storename — VARCHAR(255) — NOT NULL
- type — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- lot_address — VARCHAR(255) — NOT NULL
- postal_code — VARCHAR(10) — NOT NULL
- rating — VARCHAR
- latitude — DECIMAL(9, 6)
- longitude — DECIMAL(9, 6)
- hours — TEXT
- menu — JSONB
- images — JSONB
categories
- category_id — SERIAL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
course_categories
- course_id — INT
- category_id — INT
course_mbti
- course_id — INT
- mbti_id — INT
date_courses
- course_id — SERIAL
- course_name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — TEXT
- options — INTEGER
- images — INTEGER
- distance — DECIMAL(5, 2)
- budget — DECIMAL(5, 2)
- created_at — TIMESTAMP
date_options
- option_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
events
- event_id — SERIAL
- category_id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- image_path — VARCHAR(255)
- date — DATE
- created_at — TIMESTAMP
mbti_profiles
- id — SERIAL
- mbti_type — VARCHAR(4) — NOT NULL
- recommended_course_ids — INTEGER
mbti_types
- mbti_id — SERIAL
- mbti_type — VARCHAR(4) — NOT NULL
- 설명 — TEXT
- 특성 — TEXT
recommended_courses
- course_id — SERIAL
- user_id — INT
- selection_id — INT
- course_details — JSONB — NOT NULL
- created_at — TIMESTAMP
restaurants
- id — SERIAL
- category — VARCHAR(255)
- storename — VARCHAR(255)
- type — VARCHAR(100)
- address — VARCHAR(255)
- lot_address — VARCHAR(255)
- postal_code — VARCHAR(10)
- rating — VARCHAR
- latitude — NUMERIC(9, 6)
- longitude — NUMERIC(9, 6)
- hours — JSONB
- menu — JSONB
- images — JSONB
selection_options
- id — SERIAL
- selection_id — INT
- option_id — INT
social_logins
- social_login_id — SERIAL
- user_id — INT
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- created_at — TIMESTAMP
user_courses
- user_id — INT
- course_id — INT
- is_favorite — BOOLEAN
- saved_at — TIMESTAMP
user_preferences
- id — SERIAL
- user_id — INTEGER
- preferred_date_course_ids — INTEGER
user_profiles
- profile_id — SERIAL
- user_id — INT
- bio — TEXT
- mbti_id — INT
- profile_picture_url — VARCHAR(255)
user_selections
- selection_id — SERIAL
- user_id — INT
- distance — INT — NOT NULL
- budget — INT — NOT NULL
- address — VARCHAR(255)
- created_at — TIMESTAMP
users
- user_id — SERIAL
- email — VARCHAR(255)
- username — VARCHAR(255)
- google_id — VARCHAR(255)
- kakao_id — VARCHAR(255)
- naver_id — VARCHAR(255)
- password_hash — TEXT
- created_at — TIMESTAMP