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