ㅇㅇ
Tables (13)
Comment
- id — BIGINT(20) — Primary key — NOT NULL
- post_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
Like
- id — BIGINT(20) — Primary key — NOT NULL
- post_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- update_at — DATETIME(6) — NOT NULL
Post
- id — BIGINT(20) — Primary key — NOT NULL
- category_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- local_id — BIGINT(20) — NOT NULL
- title — VARCHAR(22)
- content — TEXT
- picture_url — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
User
- id — BIGINT(20) — Primary key — NOT NULL
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- name — VARCHAR(20)
- point — BIGINT(20)
- temp — DECIMAL(5, 1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- update_at — DATETIME(6) — NOT NULL
- marketingConsent — BOOLEAN — NOT NULL
- infoConsent — BOOLEAN — NOT NULL
- refreshToken — VARCHAR(255)
category
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
local
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- parent_id — BIGINT(20) — NOT NULL
mission
- id — BIGINT(20) — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
receive
- id — BIGINT(20) — Primary key — NOT NULL
- mission_id — BIGINT(20) — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- content — TEXT
- picture — IMAGE
- status — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- update_at — DATETIME(6) — NOT NULL
scrap
- id — BIGINT(20) — Primary key — NOT NULL
- user_id — BIGINT(20) — NOT NULL
- post_id — BIGINT(20) — NOT NULL
search_local
- id — BIGINT(20) — Primary key — NOT NULL
- local_name — VARCHAR(20) — NOT NULL
travel
- id — BIGINT(20) — Primary key — NOT NULL
trip
- id — BIGINT(20) — Primary key — NOT NULL
- vehicle_id — BIGINT(20) — NOT NULL
- distance_id — BIGINT(20) — NOT NULL
- starting_id — BIGINT(20) — NOT NULL
vehicle
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(10) — NOT NULL