Blccu
Tables (10)
comment (Untitled10)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
- post_id (Key3) — UUID — Foreign key → post.id — NOT NULL
- content (Field2) — varchar(1500) — NOT NULL
- user_name (Field) — varchar(15) — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_updated (Field4) — datetime
- date_deleted (Field6) — datetime
- blame_count (Field5) — int(11) — NOT NULL
- parent_id (Key4) — UUID — Foreign key → comment.id
- children_id (Key5) — UUID — Foreign key → comment.id
neighbor (Untitled3)
- from_user (Key2) — UUID — Foreign key → user.id — NOT NULL
- to_user (Key3) — UUID — Foreign key → user.id — NOT NULL
notification (Untitled9)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
- target_user_id (Key3) — UUID — Foreign key → user.id
- post_id (Key4) — UUID — Foreign key → post.id
- not_type (Field) — int(11) — NOT NULL
- not_url (Field2) — varchar(255)
- not_message (Field3) — varchar(255) — NOT NULL
- date_created (Field4) — datetime — NOT NULL
- is_checked (Field5) — bit(1) — NOT NULL
post (Untitled4)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
- post_background_id (Key3) — UUID — Foreign key → post_background.id — NOT NULL
- post_image_id (Key6) — UUID — Foreign key → post_image.id — NOT NULL
- post_category_id (Key5) — UUID — Foreign key → post_category.id — NOT NULL
- title (Field) — varchar(100) — NOT NULL
- content (Field2) — longtext — NOT NULL
- like_count (Field4) — int(11) — NOT NULL
- view_count (Field5) — int(11) — NOT NULL
- allow_comment (Field6) — bit(1) — NOT NULL
- scope (Field7) — int(11) — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_updated (Field8) — datetime — NOT NULL
- date_deleted (Field9) — datetime
post_background (Untitled5)
- id (Key) — UUID — Primary key — NOT NULL
- image_url (Field) — varchar(255) — NOT NULL
post_category (Untitled7)
- id (Key) — UUID — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
post_image (Untitled6)
- id (Key) — UUID — Primary key — NOT NULL
- image_url (Field) — varchar(255) — NOT NULL
sticker (Untitled8)
- id (Key) — UUID — Primary key — NOT NULL
- image_url (Field) — varchar(255) — NOT NULL
- user_id (Key2) — UUID — Foreign key → user.id
user (Untitled)
- id (Key) — UUID — Primary key — NOT NULL
- username (Field) — varchar(15) — NOT NULL
- description (Field2) — varchar(255) — NOT NULL
- profile_image (Field3) — varchar(255)
- date_created (Field4) — datetime — NOT NULL
- date_deleted (Field5) — datetime
user_auth (Untitled2)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
- authorization_code (Field2) — varchar(255) — NOT NULL
- refresh_token (Field3) — varchar(255)