sns_system_db
Tables (3)
comments (Untitled2)
- comment_id (Key) — bigint(20) — Primary key — NOT NULL
- content (Field2) — varchar(255)
- created_at (Field3) — datetime
- post_id (Key2) — bigint(20) — Foreign key → posts.post_id — NOT NULL
- user_id (id) — bigint(20) — Foreign key → users.user_id — NOT NULL
posts (Untitled)
- post_id (Key) — bigint(20) — Primary key — NOT NULL
- title (Field2) — varchar(255)
- content (Field3) — TEXT
- created_at (Field) — datetime
- user_id (id) — bigint(20) — Foreign key → users.user_id — NOT NULL
users (사용자)
- user_id (id) — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- email — varchar(255)