ODGATI

Tables (14)

board (게시글)

  • id (PK) — INT — Primary key — NOT NULL
  • tiitle (Field) — VARCHAR(30)
  • content (Field2) — TEXT
  • board_like (Field3) — INT

board_like (게시글 좋아요)

  • no (PK) — INT — Primary key — NOT NULL
  • user_id (FK) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • board_id (FK2) — INT — Foreign key → board.id — NOT NULL

img (이미지)

  • id (Key) — VARCHAR(10) — Primary key — NOT NULL
  • related_id (Field2) — VARCHAR(100)
  • related_type (Field3) — VARCHAR(100)
  • original_filename (Field4) — VARCHAR(100)
  • stored_filename (Field5) — VARCHAR(100)
  • file_path (Field6) — VARCHAR(100)

place (장소)

  • id (PK) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(10)
  • region (Field2) — VARCHAR(10)
  • description (Field3) — TEXT
  • image_url (Field4) — URL
  • place_like (Field5) — INT

place_like (CopyOf좋아요 목록)

  • no (PK) — INT — Primary key — NOT NULL
  • user_id (FK1) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • place_id (PK2) — INT — Foreign key → place.id — NOT NULL

result_ment (결과 멘트)

  • id (PK) — TEXT — Primary key — NOT NULL
  • mbti (UNIQUE) — VARCHAR(10)
  • memt (Field) — TEXT

review (후기)

  • id (PK) — INT — Primary key — NOT NULL
  • user_id (FK) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • content (Field2) — VARCHAR(10)
  • created_at (Field) — DATETIME
  • update_at (Field3) — DATETIME
  • review_like (Field4) — INT

review_ comments (댓글)

  • id (PK) — INT — Primary key — NOT NULL
  • user_id (FK1) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • review_id (FK2) — INT — Foreign key → review.id — NOT NULL
  • coment (Field) — VARCHAR(100)
  • rag_date (Field2) — DATE
  • update_date (Field3) — DATE

review_like (좋아요 목록)

  • no (PK) — INT — Primary key — NOT NULL
  • user_id (FK1) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • review_id (FK2) — VARCHAR(10) — Foreign key → review.user_id — NOT NULL

tag (태그)

  • id (PK) — INT — Primary key — NOT NULL
  • related_id (Field) — INT
  • related_type (Field2) — VARCHAR(10)
  • tag (Field3) — VARCHAR(19)

trait_question (검사 질문)

  • id (PK) — INT — Primary key — NOT NULL
  • trait_axis (Field) — VARCHAR(10)
  • Field2 — TEXT

trait_score_tag

  • id (PK) — INT — Primary key — NOT NULL
  • id (PK2) — TEXT — Foreign key → result_ment.id — NOT NULL
  • trait_axis (Field) — VARCHAR(50)
  • score (Field2) — INT
  • tag (Field3) — VARCHAR(100)

user (유저정보)

  • user_id (PK) — VARCHAR(10) — Primary key — NOT NULL
  • pasword (Field2) — VARCHAR(20)
  • username (Field) — VARCHAR(10)
  • created-at (Field3) — DATETIME
  • email (UNIQUE) — VARCHAR(100)

user_trait_score (검사결과)

  • user_id (PK) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
  • solo_together_avg (Field) — INT
  • relax_activity_avg (Field2) — INT
  • value_premium_avg (Field3) — INT
  • nature_city_avg (Field4) — INT