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