졸업 프로젝트
테이블 (3)
oauth_tokens
- id — SERIAL
- user_id — INTEGER — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- token_type — VARCHAR(50)
- expires_in — TIMESTAMP
restaurants
- id — SERIAL
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(50)
- description — TEXT
- open_time — TIME
- close_time — TIME
- serves_alcohol — BOOLEAN
- corkage_service — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — SERIAL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — TEXT
- oauth_provider — VARCHAR(50)
- oauth_id — VARCHAR(255)
- profile_image_url — TEXT
- age_range — VARCHAR(10)
- favorite_drink — VARCHAR(255)
- created_at — TIMESTAMP
- last_login — TIMESTAMP