Turning
Tables (10)
action (Untitled7)
- id (Key) — UUID — Primary key — NOT NULL
- requester_id (identifier) — UUID — Foreign key → user.id — NOT NULL
- recipient_id (identifier2) — UUID — Foreign key → user.id — NOT NULL
- skill_id (Key2) — UUID — Foreign key → skill.id — NOT NULL
- created_at (Field) — timestamp — NOT NULL
- expired_at (Field2) — timestamp — NOT NULL
- deleted_at (Field3) — timestamp
application
- id (Key2) — UUID — Primary key — NOT NULL
- user_id (identifier) — UUID — Foreign key → user.id — NOT NULL
- target_application_id (Key) — BIGINT — Foreign key → target_application.id — NOT NULL
- token (Field) — text
- spend_time (Field5) — integer — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- last_used_at (Field3) — timestamp
- trial_count (Field6) — integer — NOT NULL
- block_count (Field7) — integer — NOT NULL
- open_count (Field8) — integer — NOT NULL
- close_count (Field9) — integer — NOT NULL
- deleted_at (Field10) — timestamp
application_log (Untitled5)
- id (Key) — UUID — Primary key — NOT NULL
- application_id (Key2) — UUID — Foreign key → application.id — NOT NULL
- event (Field) — enum(pass, block, ,,,,) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
friendship (Untitled)
- id (Key) — UUID — Primary key — NOT NULL
- requester_id (identifier) — UUID — Foreign key → user.id — NOT NULL
- recipient_id (identifier2) — UUID — Foreign key → user.id — NOT NULL
- status (Field) — enum(수락대기_거절_완료) — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
- deleted_at (Field4) — timestamp
interception_phrase (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- content (Field) — varchar(255) — NOT NULL
- type (Field2) — enum(NO_BONE, DEFAULT, HARD) — NOT NULL
- language (Field3) — enum(ENGLISH, KOREAN) — NOT NULL
point_log (Untitled2)
- id (Key) — UUID — Primary key — NOT NULL
- user_id (identifier) — UUID — Foreign key → user.id — NOT NULL
- skill_id (Key2) — UUID — Foreign key → skill.id
- event (Field) — enum(skill, block...)
- change_amount (Field2) — integer — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
push_log (Untitled6)
- id (Key) — UUID — Primary key — NOT NULL
- requester_id (identifier) — UUID — Foreign key → user.id — NOT NULL
- recipient_id (identifier2) — UUID — Foreign key → user.id — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- body (Field2) — varchar(255) — NOT NULL
- push_type (Field4) — ENUM — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
skill (Untitled3)
- id (Key) — UUID — Primary key — NOT NULL
- code (Field4) — enum(....) — NOT NULL
- description (Field) — text — NOT NULL
- cost (Field3) — integer — NOT NULL
target_application (Untitled8)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(255) — NOT NULL
- app_scheme (Field2) — varchar(255) — NOT NULL
- code (Field3) — varchar(255) — NOT NULL
user
- id (identifier) — UUID — Primary key — NOT NULL
- name (user name) — varchar(255) — NOT NULL
- role (Field4) — enum(user, admin) — NOT NULL
- code (Field5) — varchar(6)
- code_expired_at (Field6) — timestamp
- email (user email) — varchar(255) — NOT NULL
- point (Field) — integer — NOT NULL
- firebase_push_token (Field2) — text
- vendor (Field7) — ENUM
- vendor_id (Field8) — varchar(255)
- key_time_start (Field9) — integer — NOT NULL
- key_time_end (Field10) — integer — NOT NULL
- daily_screen_time (Field11) — integer — NOT NULL
- timezone (Field12) — varchar(50) — NOT NULL
- created_at (.) — timestamp — NOT NULL
- deleted_at (Field3) — timestamp