study0

Tables (17)

Address (주소)

  • address_id (PK) — BIGINT — Primary key — NOT NULL
  • latitude (Field) — DECIMAL(10,8)
  • longitude (Field2) — DECIMAL(11,8)
  • address_name (Field3)

Notification (알림)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • content (Field2) — VARCHAR(255)
  • is_read (Field3) — BOOLEAN
  • notifiable_id (Field4) — BIGINT
  • notifiable_type (Field) — VARCHAR

Photo (사진)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • image_url (Field) — VARCHAR
  • photo_type (Field2) — VARCHAR
  • review_id (Field3) — BIGINT
  • store_id (Field4) — BIGINT
  • inquiry_id (Field5) — BIGINT
  • created_at (Field6) — DATETIME
  • updated_at (Field7) — DATETIME

Point_Transaction (포인트 거래 내역)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_mission_id (FK2) — BIGINT — Foreign key → member_misson.id — NOT NULL
  • description (Field2) — VARCHAR(255)
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • amount (Field) — INT
  • type (Field4) — ENUM
  • created_at (Field3) — DATETIME

Review (리뷰)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK2) — BIGINT — Foreign key → member.id — NOT NULL
  • rating (Field)
  • content (Field2)
  • created_at (Field3) — DATETIME
  • updated_at (Field4)
  • store_id (FK4) — BIGINT — Foreign key → Store.id — NOT NULL
  • member_mission_id (FK3) — BIGINT — Foreign key → member_misson.id — NOT NULL

Review_Answer (리뷰 점주 답글)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • review_id (FK) — BIGINT — Foreign key → Review.id — NOT NULL
  • member_id (FK2) — BIGINT — Foreign key → member.id — NOT NULL
  • content (Field)
  • created_at (Field2) — DATETIME

Store (가게)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • description (Field5) — TEXT
  • member_id (FK2) — BIGINT — Foreign key → member.id — NOT NULL
  • category_id (FK3) — BIGINT — Foreign key → category.id — NOT NULL
  • average_rating (Field7) — FLOAT
  • address_id (FK4)

category (카테고리)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR

inquiry (문의)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • type (Field) — VARCHAR
  • title (Field2) — VARCHAR(255)
  • content (Field3) — TEXT
  • status (Field4) — VARCHAR
  • created_at (Field5) — DATETIME

inquiry_answer (문의 답변)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • inquiry_id (FK) — BIGINT — Foreign key → inquiry.id — NOT NULL
  • content (Field2) — TEXT
  • created_at (Field) — DATETIME
  • member_id (FK2) — BIGINT — Foreign key → member.id — NOT NULL

member (회원)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • password (Field2) — VARCHAR(255)
  • nickname (Field3) — VARCHAR(50)
  • gender (Field4) — ENUM('MALE', 'FEMALE', 'NONE')
  • birthday (Field5) — DATE
  • point (Field6) — INT
  • social_type (Field7) — VARCHAR(20)
  • social_id (Field8) — VARCHAR(255)
  • created_at (Field9) — DATETIME
  • updated_at (Field10) — DATETIME
  • phone_number (Field13) — VARCHAR(20)
  • phone_verified_at (Field14) — DATETIME
  • role (Field15) — ENUM
  • status (Field12) — VARCHAR
  • address_id (FK)

member_food_preference (회원 선호 음식)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • category_id (FK2) — BIGINT — Foreign key → category.id — NOT NULL

member_misson (회원-미션)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • mission_id (FK2) — BIGINT — Foreign key → mission.id — NOT NULL
  • status (Field2) — VARCHAR
  • completed_at (Field3) — DATETIME
  • created_at (Field) — DATETIME
  • verification_code (Field4) — VARCHAR

member_terms (회원 약관 동의)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • term_id (FK) — BIGINT — Foreign key → terms.id — NOT NULL
  • member_id (FK2) — BIGINT — Foreign key → member.id — NOT NULL
  • created_at (Field) — DATETIME

mission (미션)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • store_id (FK) — BIGINT — Foreign key → Store.id — NOT NULL
  • title (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • reward_point (Field3) — INT
  • start_date (Field5) — DATETIME
  • end_date (Field6) — DATETIME
  • created_at (Field4) — DATETIME

notification_setting (알림 설정)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • member_id (FK) — BIGINT — Foreign key → member.id — NOT NULL
  • event_alerts (Field) — BOOLEAN
  • review_reply_alerts (Field2) — BOOLEAN
  • inquiry_reply_alerts (Field3) — BOOLEAN

terms (약관)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — TEXT
  • is_mandatory (Field3) — BOOLEAN