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