test

Tables (6)

hashtag

  • id — int — Primary key — NOT NULL
  • name — varchar2(3000) — NOT NULL
  • category — varchar2(300)

image

  • id — int — Primary key — NOT NULL
  • img_url — varchar2(3000) — NOT NULL
  • store_id — int
  • member_id — varchar2(300) — NOT NULL

member

  • id — varchar2(300) — Primary key — NOT NULL — 초대 링크 외부 노출 이슈로 varchar type
  • character_id — int — NOT NULL
  • exp — int — NOT NULL
  • is_deleted — int — NOT NULL
  • nickname — varchar2(300)
  • img_url — varchar2(3000)
  • email — varchar2(3000)
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • gender — varchar2(300) — Enum
  • birth — date
  • grade — int — NOT NULL
  • self_mbti_id — int — (테이블 데이터는 16개만 존재)
  • perceived_mbti_id — int — 남이 지정한 평균의 mbti(캐시용)
  • device_token — varchar2(3000)
  • oauth_id — varchar2(3000)
  • role — varchar2(300)
  • refresh_token — varchar2(3000)
  • qr_url — varchar2(300) — NOT NULL — 유저의 큐알코드

review

  • id — int — Primary key — NOT NULL
  • member_id — varchar2(300) — NOT NULL
  • store_id — int — NOT NULL
  • is_deleted — int — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • score — NUMBER(5, 2) — NOT NULL — 1~5
  • content — varchar2(3000)

store

  • id — int — Primary key — NOT NULL
  • name — varchar2(300) — NOT NULL
  • opened_at — date
  • closed_at — date
  • contact_number — varchar2(300)
  • main_category — varchar2(300) — 식당/ Enum
  • sub_category — varchar2(300) — 이탈리 식당 / Enum
  • floor — varchar2(300) — NOT NULL — Enum
  • description — varchar2(3000)
  • avg_score — NUMBER(1, 1)
  • review_count — int — NOT NULL

store_hashtag

  • id — int — Primary key — NOT NULL
  • hashtag_id — int — NOT NULL
  • store_id — int — NOT NULL
  • count — int