movv
Tables (18)
affiliate_request (제휴 요청)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → users.id — NOT NULL
- store_id (Key3) — Foreign key → stores.id — NOT NULL
- created_at (Field)
affiliated_map (제휴 가게 관계테이블)
- id (Key2) — Primary key — NOT NULL
- university_id (Key4) — Foreign key → universities.id — NOT NULL
- user_id (Key) — Foreign key → users.id — NOT NULL
- store_id (Key3) — Foreign key → stores.id — NOT NULL
- benefit_detail (Field4)
- vailid_from_date (Field2)
- valid_to_date (Field3)
- created_at (Field)
files (파일)
- id (Key) — Primary key — NOT NULL
- url (Field2)
- original_name (Field3)
- filename (Field)
- type (Field6)
- created_at (Field4)
- key, storage, etc... (Field5)
menus (학식당 메뉴)
- id (Key) — Primary key — NOT NULL
- dining_hall_id (Key2) — Foreign key → university_dining_halls.id — NOT NULL
- menu (Field)
- date (Field3)
- type (Field4)
- created_at (Field2)
notification_types (알림 타입)
- id (Key) — Primary key — NOT NULL
- code (Field)
- display_name (Field2)
- created_at (Field3)
notifications (알림)
- id (Key) — Primary key — NOT NULL
- notification_type_id (Key2) — Foreign key → notification_types.id — NOT NULL
- sender_id (Key3) — uuid — Foreign key → users.id — NOT NULL
- receiver_id (Key4) — uuid — Foreign key → users.id — NOT NULL
- title (Field)
- description (Field2)
- created_at (Field3)
phone_verification_log (핸드폰 인증 로그)
- id (Key) — uuid — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → users.id — NOT NULL
- verify_code (Field2)
- expired_at (Field3)
- created_at (Field)
profile_images (앱 기본 프로필 사진)
- id (Key) — Primary key — NOT NULL
- image_file_id (Key2) — Foreign key → files.id — NOT NULL
- name (Field)
- created_at (Field2)
store_likes (제휴 가게 즐겨찾기)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → users.id — NOT NULL
- store_id (Key3) — Foreign key → stores.id — NOT NULL
- created_at (Field)
store_review_photos (제휴 가게 리뷰 사진들)
- id (Key) — Primary key — NOT NULL
- review_id (Key2) — Foreign key → store_reviews.id — NOT NULL
- file_id (Key3) — Foreign key → files.id — NOT NULL
- created_at (Field2)
store_reviews (제휴 가게 리뷰)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → users.id — NOT NULL
- store_id (Key3) — Foreign key → stores.id — NOT NULL
- rating (Field)
- content (Field2)
store_type (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- order (Field3)
- created_at (Field2)
stores (제휴 가게)
- id (Key) — Primary key — NOT NULL
- store_type_id (Key2) — Foreign key → store_type.id — NOT NULL
- name (Field)
- description (Field10)
- category (Field2)
- phone (Field3)
- address (Field4)
- latitude (Field5)
- longitude (Field6)
- open_hour (Field7)
- close_hour (Field8)
- created_at (Field9)
universities (학교)
- id (Key) — uuid — Primary key — NOT NULL
- name (Field)
- domain (Field2)
- address (Field4)
- created_at (Field3)
university_dining_hall_likes (학식당 즐겨찾기)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → users.id — NOT NULL
- dining_hall_id (Key3) — Foreign key → university_dining_halls.id — NOT NULL
- created_at (Field)
university_dining_halls (학식당)
- id (Key) — Primary key — NOT NULL
- university_id (Key2) — uuid — Foreign key → universities.id — NOT NULL
- name (Field6)
- address (Field)
- domain (Field2)
- open_hour (Field4)
- close_hour (Field5)
- created_at (Field3)
user_university_info (사용자 대학 상세 정보)
- id (Key2) — Primary key — NOT NULL
- user_id (Key) — uuid — Foreign key → users.id — NOT NULL
- collage_name (Field)
- department_name (Field2)
- major_name (Field3)
- certification_file_id (Key3) — Foreign key → files.id — NOT NULL
- undergraduate_number (Field4)
users (사용자)
- id (Key) — uuid — Primary key — NOT NULL
- university_id (Key2) — uuid — Foreign key → universities.id — NOT NULL
- profile_image_id (Key3) — Foreign key → profile_images.id — NOT NULL
- account_id (Field3) — varcharr
- password (Field4) — varchar
- name (Field6)
- nickname (Field7)
- phone (Field5) — varchar
- birth (Field) — timestamp
- created_at (Field2) — timestamp
- point (Field8)