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 (타입 이미지)