Blccu V2
Tables (13)
announcement (Untitled2)
- id (Key) — UUID — Primary key — NOT NULL
- title (Field) — string — NOT NULL
- content (Field2) — string — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_updated (Field5) — datetime — NOT NULL
- date_deleted (Field4) — datetime
comment (Untitled10)
- id (Key) — UUID — Primary key — NOT NULL
- post_id (Key3) — UUID — Foreign key → posts.id — NOT NULL
- content (Field2) — string — NOT NULL
- user_name (Field) — string — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_updated (Field4) — datetime
- date_deleted (Field6) — datetime
- blame_count (Field5) — number — NOT NULL
- parent_id (Key4) — UUID — Foreign key → comment.id
- writer_id (Field62) — number — Foreign key → user.kakaoId — NOT NULL
like (Untitled13)
- id (Key) — UUID — Primary key — NOT NULL
- from_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
- post_id (Key2) — UUID — Foreign key → posts.id — NOT NULL
neighbor (Untitled3)
- id (Key) — UUID — Primary key — NOT NULL
- from_user (Key2) — number — Foreign key — NOT NULL
- to_user (Field6) — number — Foreign key → user.kakaoId — NOT NULL
notification (Untitled9)
- id (Key) — UUID — Primary key — NOT NULL
- target_user_id (Key3) — UUID — Foreign key
- user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
- not_type (Field) — number — NOT NULL
- not_url (Field2) — string
- not_message (Field3) — string — NOT NULL
- date_created (Field4) — datetime — NOT NULL
- date_deletedd (Field7) — datetime
- is_checked (Field5) — boolean — NOT NULL
post_background (Untitled5)
- id (Key) — UUID — Primary key — NOT NULL
- image_url (Field) — string — NOT NULL
post_category (Untitled7)
- id (Key) — UUID — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
posts (Untitled4)
- id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
- postBackgroundId (Key3) — UUID — Foreign key → post_background.id — NOT NULL
- postCategoryId (Key5) — UUID — Foreign key → post_category.id — NOT NULL
- userKakaoId (Field62) — number — Foreign key → user.kakaoId — NOT NULL
- title (Field) — string — NOT NULL
- like_count (Field4) — number — NOT NULL
- view_count (Field5) — number — NOT NULL
- comment_count (Field13) — number — NOT NULL
- allow_comment (Field6) — boolean — NOT NULL
- scope (Field7) — number — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- date_updated (Field8) — datetime — NOT NULL
- date_deleted (Field9) — datetime
- isPublished (Field2) — boolean — NOT NULL
- content (Field11) — longtext — NOT NULL
- image_url (Field10) — string
- main_image_url (Field12) — string
report (Untitled6)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
- title (Field) — string — NOT NULL
- content (Field2) — string — NOT NULL
- date_created (Field3) — datetime — NOT NULL
- report_url (Field4) — string
sticker (Untitled8)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
- isDefault (Field2) — boolean — NOT NULL
- image_url (Field) — number — NOT NULL
sticker_block (Untitled12)
- id (Key3) — UUID — Primary key — NOT NULL
- sticker_id (Key2) — UUID — Foreign key → sticker.id — NOT NULL
- post_id (Key) — UUID — Foreign key → posts.id — NOT NULL
- depth (Field) — number — NOT NULL
- fill (Field2) — string — NOT NULL
- x (Field3) — point — NOT NULL
- y (Field4) — point — NOT NULL
- width (Field5) — string — NOT NULL
- height (Field6) — string — NOT NULL
sticker_category (Untitled11)
- id (Key) — uuid — Primary key — NOT NULL
- name (Field) — string
- sticker_id (Key2) — UUID — Foreign key → sticker.id — NOT NULL
user (Untitled)
- kakaoId (Field6) — number — 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
- current_refresh_token (Field7) — string — NOT NULL
- isAdmin (Field8) — boolean — NOT NULL