PJ

Tables (10)

black_list

  • black_list_id — INT
  • user_id — INT
  • deleted_at — TIMESTAMP
  • valid_at — TIMESTAMP

boards

  • board_id — INT
  • title — VARCHAR(255) — NOT NULL
  • plan_id — INT
  • user_id — INT
  • like_id — INT
  • created_at — TIMESTAMP

child_comments

  • child_comment_id — INT
  • content — TEXT — NOT NULL
  • comment_id — INT
  • user_id — INT
  • created_at — TIMESTAMP

city_tags

  • tag_id — INT
  • city_name — VARCHAR(255) — NOT NULL

comments

  • comment_id — INT
  • content — TEXT — NOT NULL
  • board_id — INT
  • user_id — INT
  • created_at — TIMESTAMP

follows

  • follow_id — INT
  • follower_id — INT
  • following_id — INT

likes

  • like_id — INT
  • user_id — INT

plan_details

  • plan_detail_id — INT
  • place — VARCHAR(255) — NOT NULL
  • order — INT — NOT NULL
  • date — DATE — NOT NULL

plans

  • plan_id — INT
  • title — VARCHAR(255) — NOT NULL
  • plan_detail_id — INT
  • is_published — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP

users

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP