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