Remind-Newsfeed

Tables (5)

account (Untitled)

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password (passwrod) — varchar(50) — NOT NULL
  • username (name) — varchar(20) — NOT NULL — 한글 기준 최대 6자
  • birthdate — date — NOT NULL — YYYY-MM-DD
  • created_at — datetime — NOT NULL
  • updated_at (Field) — datetime — NOT NULL
  • nickname (Field2)

comments (CopyOfCopyOfUntitled)

  • id — bigint — Primary key — NOT NULL
  • post_id (id2) — bigint — Foreign key → posts.id — NOT NULL
  • account_id (id3) — bigint — Foreign key → account.id — NOT NULL
  • coment (field) — varchar(2000) — NOT NULL — 한글 기준 최대 650자
  • created_at — datetime — NOT NULL
  • updated_at (Field) — datetime — NOT NULL

followers (CopyOfUntitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • follower_id (id) — bigint — Foreign key → account.id — NOT NULL
  • following_id (id2) — bigint — Foreign key → account.id — NOT NULL

post_like (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (id) — bigint — Foreign key → posts.id — NOT NULL
  • account_id (id2) — bigint — Foreign key → account.id — NOT NULL

posts (CopyOfUntitled)

  • id — bigint — Primary key — NOT NULL
  • title (Field2) — varchar(100) — NOT NULL — 한글 기준 최대 30자
  • content (email) — varchar(2000) — NOT NULL — 한글 기준 최대 650자
  • like_count (name) — varchar(20) — NOT NULL — 한글 기준 최대 6자
  • created_at — datetime — NOT NULL
  • updated_at (Field) — datetime — NOT NULL