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