dd

Tables (12)

Copy Of cards (CopyOfcards)

  • id — bigint — Primary key — NOT NULL
  • ended_at — time(6)
  • started_at — time(6)
  • column_id — bigint
  • address — varchar(255)
  • memo — varchar(255)
  • place_name — varchar(255)
  • title — varchar(255)

card_posts

  • id — bigint — Primary key — NOT NULL
  • card_id — bigint
  • post_id — bigint

cards

  • id — bigint — Primary key — NOT NULL
  • ended_at — time(6)
  • started_at — time(6)
  • column_id — bigint
  • address — varchar(255)
  • memo — varchar(255)
  • place_name — varchar(255)
  • title — varchar(255)

columns

  • id — bigint — Primary key — NOT NULL
  • date — date
  • default_value — bit
  • plan_id — bigint
  • title — varchar(255)

comment_likes

  • id — bigint — Primary key — NOT NULL
  • comment_id — bigint
  • user_id — bigint

comments

  • id — bigint — Primary key — NOT NULL
  • likes_count — bigint — NOT NULL
  • post_id — bigint
  • user_id — bigint
  • content — varchar(255)

coworkers

  • id — bigint — Primary key — NOT NULL
  • plan_id — bigint
  • user_id — bigint

images

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • modified_at — datetime(6)
  • post_id — bigint
  • changed_file_name — varchar(255)
  • original_file_name — varchar(255)
  • path — varchar(255)

plans

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255)

post_likes

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint
  • user_id — bigint

posts

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • likes_count — bigint — NOT NULL
  • modified_at — datetime(6)
  • user_id — bigint
  • views_count — bigint — NOT NULL
  • address — varchar(255)
  • content — varchar(255)
  • place_name — varchar(255)
  • title — varchar(255)
  • theme_enum — enum

users

  • id — bigint — Primary key — NOT NULL
  • auth_user_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • modified_at — datetime(6)
  • bio — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • profile_image — varchar(255)
  • user_role — enum
  • user_status — enum