여행
테이블 (9)
destination (목적지)
- id (Key) — Long — 기본 키 — NOT NULL
- reservation_id (Key2) — Long — 외래 키 → reservation.id — NOT NULL
- name (여행지 이름) — varchar(255)
- address (주소) — varchar(255)
- season (성수기) — enum
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
reservation (여행예약)
- id (Key) — Long — 기본 키 — NOT NULL
- name (예약자 이름) — varchar(255)
- start (출발 날짜) — datetime
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
거래 후기 (Untitled4)
- id (Key) — bigint — 기본 키 — NOT NULL
- product_id (Key4) — bigint — 외래 키 → 물품.id — NOT NULL
- reviewer_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- reviewee_id (Key3) — bigint — 외래 키 → 회원.id — NOT NULL
- sale_review_type (Field) — int
- content (Field2) — varchar(500)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
매너 (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- evalutor_id (Key3) — bigint — 외래 키 → 회원.id — NOT NULL
- score (Field) — int
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
물품 (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- buyer_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- seller_id (Key3) — bigint — 외래 키 → 회원.id — NOT NULL
- price (Field) — bigint
- title (Field2) — varchar(100)
- discription (Field3) — varchar(100)
- location (Field4) — varchar(20)
- product_state (Field5) — int
- thumb_nail_image (Field6) — varchar(250)
- view_cnt (Field7) — int
- refresh_cnt (Field8) — int
- created_at (Field9) — timestamp
- updated_at (Field10) — timestamp
- refreshed_at (Field11) — timestamp
알림 (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key3) — bigint — 외래 키 → 회원.id — NOT NULL
- notification_type (Field) — int
- identifier (Field2) — varchar(50)
- is_read (Field3) — boolean
- is_valid (Field4) — boolean
- created_at (Field5) — timestamp
채팅방 정보 (Untitled6)
- id (Key) — bigint — 기본 키 — NOT NULL
- product_id (Field) — bigint
- product_image (Field2) — string
- first_user_id (Field3) — bigint
- second_user_id (Field4) — bigint
- identifier (Field5) — string
- chat_messages (Field6) — array
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp
채팅방 참여자 (Untitled7)
- id (Key) — bigint — 기본 키 — NOT NULL
- char_room_id (Key2) — bigint — 외래 키 → 채팅방 정보.id — NOT NULL
- user_id (Field) — bigint
- out (Field2) — boolean
- read_message_size (Field3) — bigint
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
회원 (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- login_id (Field) — varchar(50)
- nickname (Field2) — varchar(30)
- location (Field3) — varchar(20)
- profile_url (Field4) — varchar(250)
- manner (Field5) — double
- created_at (Field6) — timestamp
- updated_at (Field7) — timestamp