freeLog
Tables (5)
comment (Untitled2)
- id (Key) — Primary key — NOT NULL
- user_id (user pk) — int(11) — Foreign key → user.id — NOT NULL
- post_id (post pk) — int(11) — Foreign key → post.id — NOT NULL
- resource_id (pk2) — int(11) — Foreign key → resource.id — NOT NULL
- text (Field)
- is_active (Field3)
- created_at (Field4)
- updated_at (Field5)
follow (Untitled3)
- id (Key) — Primary key — NOT NULL
- follower_id (pk) — int(11) — Foreign key → user.id — NOT NULL
- followee_id (pk2) — int(11) — Foreign key → user.id — NOT NULL
- is_active (Field) — tinyint(1)
- created_at (u)
- updated_at (Field2)
post
- id (pk) — int(11) — Primary key — NOT NULL
- user_id (user_pk) — int(11) — Foreign key → user.id — NOT NULL
- title (post title) — varchar
- content (post content) — varchar
- like (post like) — int(11)
- is_active (Field) — tinyint(1)
- created_at (Field2)
- updated_at (Field3)
resource (Untitled)
- id (pk) — int(11) — Primary key — NOT NULL
- post_id (post pk) — int(11) — Foreign key → post.id — NOT NULL
- position (Field4)
- text (Field5)
- link (s3 link) — varchar
- is_active (Field) — tinyint(1)
- created_at (Field2)
- updated_at (Field3)
user
- id (pk) — int(11) — Primary key — NOT NULL
- uuid (UUID) — varchar(36)
- username (@user alias) — varchar
- email — varchar
- password (pw) — password
- photo (profile photo) — varchar
- is_active (삭제여부) — tinyint(1)
- created_at (생성날짜) — datetime
- updated_at (수정날짜) — datetime