ㅇㅇ

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