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)