so_new_wedding

Tables (16)

Career (경력)

  • id (PK) — INT — Primary key — NOT NULL
  • expert_info_id (FK) — INT — Foreign key → ExpertInfo.id
  • title (경력사항) — VARCHAR(20), NOT NULL
  • explanation (경력 설명) — VARCHAR(300), NOT NULL
  • start_date (시작일) — TIMESTAMP
  • end_date (종료일) — TIMESTAMP

ChatMacro (채팅 매크로)

  • id (PK) — INT — Primary key — NOT NULL
  • expert_info_id (FK) — INT — Foreign key → ExpertInfo.id
  • content (매크로 내용) — TEXT

ChatRoom (채팅방)

  • id (PK) — INT — Primary key — NOT NULL
  • user_id (FK) — INT — Foreign key → User.id
  • expert_id (FK2) — INT — Foreign key → User.id

Estimation (견적)

  • id (PK) — INT — Primary key
  • user_id (FK) — INT — Foreign key → User.id
  • expert_id (FK2) — INT — Foreign key → User.id
  • available_area (활동 가능 지역) — ENUM(20)
  • appeal (소개 및 어필) — VARCHAR
  • discount (할인 금액) — INT
  • total_price (총 요금) — INT
  • created_at (생성일) — TIMESTAMP
  • updated_at (최근 수정일) — TIMESTAMP

ExampleImage (예시 이미지)

  • id (PK) — INT — Primary key — NOT NULL
  • expert_info_id (FK) — INT — Foreign key → ExpertInfo.id
  • image (서비스 예시 이미지) — VARCHAR

ExpertInfo (전문가)

  • id (PK) — INT — Primary key
  • user_id (FK) — INT — Foreign key → User.id
  • available_area (활동 가능 지역) — ENUM(20)
  • appeal (소개 및 어필) — VARCHAR(300) — NOT NULL
  • created_at (생성일) — TIMESTAMP
  • updated_at (최근 수정일) — TIMESTAMP

Message (메세지)

  • id (PK) — INT — Primary key — NOT NULL
  • room_id (FK) — INT — Foreign key → ChatRoom.id — NOT NULL
  • sender_id (FK2) — INT — Foreign key → User.id
  • content (메세지 내용) — TEXT, not null — NOT NULL
  • image (채팅 메시지 이미지) — VARCHAR
  • is_read (메세지 읽음 여부) — BOOLEAN — NOT NULL
  • timestamp (메세지 전송 시간) — TIMESTAMP

Notification (알림)

  • id (PK) — INT — Primary key — NOT NULL
  • reciever_id (FK) — INT — Foreign key → User.id
  • title (알림 제목) — VARCHAR(20), not null
  • message (알림 내용) — VARCHAR(100), not null
  • notification_type (알림 유형) — ENUM
  • is_read (알림 읽음 여부) — BOOLEAN
  • created_at (알림 생성 시간) — TIMESTAMP

ProvideService (제공 서비스)

  • id (PK) — INT — Primary key — NOT NULL
  • expert_info_id (FK) — INT — Foreign key → ExpertInfo.id
  • service (서비스) — ENUM
  • charge (요금) — INT

Rating (별점)

  • id (PK) — INT — Primary key — NOT NULL
  • reservation_id (FK) — INT — Foreign key → Reservation.id — NOT NULL
  • score (별점) — DECIMAL(2,1)

Reservation (예약 내역)

  • id (PK) — INT — Primary key — NOT NULL
  • estimation_id (FK) — INT — Foreign key → Estimation.id
  • status (상태) — ENUM

Review (리뷰)

  • id (PK) — INT — Primary key — NOT NULL
  • reservation_id (FK) — INT — Foreign key → Reservation.id — NOT NULL
  • title (제목) — CHAR(50)
  • content (내용) — VARCHAR(500)

ReviewImages (리뷰 이미지)

  • id (PK) — INT — Primary key — NOT NULL
  • review_id (FK) — INT — Foreign key → Review.id — NOT NULL
  • image (리뷰이미지) — VARCHAR

SeletedService (선택한 서비스)

  • id (PK) — INT — Primary key — NOT NULL
  • estimation_id (FK) — INT — Foreign key → Estimation.id
  • service_id (FK2) — INT — Foreign key → ProvideService.id — NOT NULL

User (유저)

  • id (PK) — INT — Primary key
  • email (이메일) — VARCHAR(30) — NOT NULL
  • name (이름) — VARCHAR(10)
  • phone_number (전화번호) — VARCHAR(13)
  • profile_image (프로필 사진) — VARCHAR
  • preferred_service (선호 서비스) — ENUM
  • preferred_area (선호 지역) — ENUM
  • is_active (활성화) — BOOLEAN
  • is_superuser (어드민 여부) — BOOLEAN
  • is_expert (전문가 여부) — BOOLEAN
  • last_login (마지막로그인) — TIMESTAMP
  • created_at (생성일) — TIMESTAMP
  • updated_at (최근 수정일) — TIMESTAMP

WithdrawManager (탈퇴관리)

  • id (PK) — Primary key
  • user_id (FK) — INT — Foreign key → User.id
  • reason (탈퇴사유) — TEXT
  • date (탈퇴일자) — TIMESTAMP