ODP
Tables (5)
comment (댓글)
- id (PK) — BIGINT — Primary key — NOT NULL
- content (Field) — TEXT
- created_at (Field2) — DATE
- user_id (PK2) — BIGINT — Foreign key → user_table.id
- review_id (PK3) — BIGINT — Foreign key → review.id — NOT NULL
plan (계획)
- id (PK) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(255)
- start_date (Field2) — DATE
- end_date (Field3) — DATE
- description (Field4) — VARCHAR(255)
- create_at (Field5) — DATE
- modified_at (Field6) — DATE
- user_id (PK2) — BIGINT — Foreign key → user_table.id
plan_detail (여행지)
- id (PK) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(255)
- location (Field7) — VARCHAR(255)
- lat (Field2) — DECIMAL(9,6)
- lng (Field3) — DECIMAL(9,6)
- img (Field4) — VARCHAR(2048)
- day (Field5) — TINYINT UNSIGNED
- seq (Field6) — TINYINT UNSIGNED
- plan_id (PK2) — BIGINT — Foreign key → plan.id — NOT NULL
review (후기)
- id (PK) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(50)
- content (Field2) — TEXT
- locate (Field7) — VARCHAR(50)
- img (Field3) — VARCHAR(2048)
- created_at (Field4) — DATE
- modified_at (Field8) — DATE
- is_public (Field5) — TINYINT(1)
- view (Field6) — INT
- user_id (PK2) — BIGINT — Foreign key → user_table.id
- id (PK3) — BIGINT — Foreign key → plan.id — NOT NULL
user_table (유저)
- id (PK) — BIGINT — Primary key
- email (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- name (Field3) — VARCHAR(30)
- birthday (Field4) — DATE