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