졸업 프로젝트

테이블 (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