SeaTea_Demo

Tables (15)

Member (Untitled)

  • Id (Key) — long — Primary key — NOT NULL
  • name (Field) — char
  • email (Field2) — char
  • provider (로그인 형식) — enum
  • password (Field3) — char
  • created_at (Field4) — datetime
  • update_at (Field5) — datetime

Member (사용자)

  • id (Key) — long — Primary key — NOT NULL
  • email (Field) — char
  • passwd (Field2) — char
  • nickname (Field3) — char
  • profile_image (Field4)
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

Place (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • type (Key2) — long — Foreign key → TastingNotes.id — NOT NULL
  • name (Field) — char
  • address (Field2) — char
  • road_address (Field3) — char
  • lat (Field4) — double
  • lng (Field5) — double
  • phone (Field6) — char
  • openingHours (Field11) — char
  • description (Field7) — char
  • note (Field8) — char
  • created_at (Field9) — datetime
  • updated_at (Field10) — datetime

Space (공간)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — char
  • address (Field2) — char
  • road_address (Field3) — char
  • lat (Field4) — double
  • lng (Field5) — double
  • phone (Field6) — char
  • openingHours (Field11) — char
  • description (Field7) — char
  • note (Field8) — char
  • created_at (Field9) — datetime
  • updated_at (Field10) — datetime

Space_tasting_note_type (공간과 타입의 매핑)

  • id (pk) — long — Primary key — NOT NULL
  • type_id (유형 외래키) — long — Foreign key → Space.id — NOT NULL
  • space_id (공간 외래키) — long — Foreign key → tasting_note_type.id — NOT NULL

TastingNotes (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — char
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

diagnoisis_answer (사용자가 실제로 택한 응답)

  • id (기본키) — longc — Primary key — NOT NULL
  • session_id (세션 fk) — long — Foreign key → diagnosis_session.id — NOT NULL
  • question_id (질문 fk) — long — Foreign key → diagnosis_question.id — NOT NULL
  • option_id (응답 fk) — long — Foreign key → diagnoisis_option.id — NOT NULL
  • created_at (생성일자) — datetime

diagnoisis_option (상세진단 질문의 선택가능한 대답)

  • id (기본키) — long — Primary key — NOT NULL
  • question_id (질문의 FK) — long — Foreign key → diagnosis_question.id — NOT NULL
  • label (선택가능한 보기) — char
  • value (보기의 코드) — char
  • weight (각 코드당의 점수) — char
  • is_actived (활성여부) — boolean

diagnosis (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • member_id (Key2) — long — Foreign key → Member.Id — NOT NULL
  • tastingNote_id (Key3) — long — Foreign key → TastingNotes.id — NOT NULL
  • created_at (Field)

diagnosis_question (상세진단 질문)

  • id (기본키) — long — Primary key — NOT NULL
  • order_no (질문 순서) — int
  • title (질문 제목) — char
  • ui_type (선택 케이스) — enum
  • is_active (Field2) — boolean

diagnosis_session (진단(공통))

  • id (기본키) — long — Primary key — NOT NULL
  • member_id (meber fk) — long — Foreign key → Member.id — NOT NULL
  • type_id (type_fk) — long — Foreign key → tasting_note_type.id — NOT NULL
  • mode (상세/간단 선택) — enum
  • created_at (생성일자) — datetime

member_saved_space (찜한 공간 (티백))

  • id (pk) — long — Primary key — NOT NULL
  • created_at (생성일자) — datetime
  • member_id (사용자 외래키) — long — Foreign key → Member.id — NOT NULL
  • space_id (공간 외래키) — long — Foreign key → Space.id — NOT NULL

quick_keyword (간단진단용 키워드)

  • id (기본키) — long — Primary key — NOT NULL
  • name (키워드) — char
  • weight (각 키워드 당의 점수) — char
  • is_active (Field) — boolean

quick_session_keyword (사용자가 실제로 고른 응답)

  • id (Key) — long — Primary key — NOT NULL
  • keyword_id (키워드 응답fk) — long — Foreign key → quick_keyword.id — NOT NULL
  • session_id (세션 fk) — long — Foreign key → diagnosis_session.id — NOT NULL

tasting_note_type (휴식유형)

  • id (기본키) — long — Primary key — NOT NULL
  • code (내부코드) — char
  • display_name (표시 이름) — char
  • subtitle (부제) — char
  • description (설명) — char
  • image_url (타입 이미지)