Kkodac
Tables (7)
Comment (CopyOfCopyOfUntitled)
- id (Key2) — int — Primary key — NOT NULL
- post_id (Key22) — int — Foreign key → Post.id — NOT NULL
- user_id (Key222) — int — Foreign key → Post.user_id — NOT NULL
- description (Field3) — varchar
- created_at (Field6) — date
- updated_at (Field7) — date
File (CopyOfCopyOfUntitled2)
- id (Key2) — int — Primary key — NOT NULL
- url (Field) — varchar
- original_name (Field2) — varchar
- created_at (Field6) — date
Filemapper (mapper)
- id (Key2) — int — Primary key — NOT NULL
- post_id (Key22) — int — Foreign key → Post.id — NOT NULL
- file_id (Key23) — int — Foreign key → File.id — NOT NULL
- post_id (Field2) — varchar
- created_at (Field6) — date
Follow (Subscribe)
- id (Key2) — int — Primary key — NOT NULL
- user_id (Key22) — int — Foreign key → User.id — NOT NULL
- follower_id (Key222) — int — Foreign key → User.file_id — NOT NULL
- created_at (Field6) — date
Like (CopyOfCopyOfCopyOfUntitled)
- id (Key2) — int — Primary key — NOT NULL
- user_id (Key22) — int — Foreign key → User.id — NOT NULL
- post_id (Key222) — int — Foreign key → Post.user_id — NOT NULL
- created_at (Field6) — date
Post (CopyOfUntitled)
- id (Key2) — int — Primary key — NOT NULL
- user_id (Key22) — int — Foreign key → User.id — NOT NULL
- file_id (Key23) — int — Foreign key → File.id — NOT NULL
- title (Field2) — varchar
- description (Field3) — varchar
- category (Field5) — varchar
- created_at (Field6) — date
- updated_at (Field7) — date
User (Untitled)
- id (Key2) — int — Primary key — NOT NULL
- file_id (Key22) — int — Foreign key → File.id — NOT NULL
- user_id (Field) — varchar
- password (Field2) — varchar
- nickname (Field3) — varchar
- introduction (Field5) — varchar
- created_at (Field6) — date
- updated_at (Field7) — date