scheduler

Tables (15)

Untitled (user)

  • Key (idx) — int — Primary key — NOT NULL — auto Increament
  • Key (login_idx) — int — Foreign key → Untitled.Key
  • Key (kakao_idx) — int — Foreign key → Untitled.Key
  • Field (nickname) — varchar — NOT NULL
  • Field (email) — varchar — NOT NULL — unique
  • Field (role) — enum(int) — NOT NULL — {0: "general", 1: "manager", 2: "master"}
  • Field (interest_count) — int

Untitled (personal_schedule)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Key (user_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (time) — timestamp — NOT NULL
  • Field (contents) — varchar — NOT NULL
  • Field (priority) — boolean — NOT NULL

Untitled (interest_schedule)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Key (interest_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (time) — timestamp — NOT NULL
  • Field (contents) — varchar — NOT NULL
  • Field (priority) — boolean — NOT NULL

Untitled (interest)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Field (interest) — varchar — NOT NULL — unique
  • Field (is_assigned) — boolean — NOT NULL
  • Field (expiration_date) — timestamp

Untitled (ask)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Key (user_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ask_category_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (contents) — varchar — NOT NULL
  • Field (reply) — text
  • Field (created_at) — timestamp — NOT NULL

Untitled (user_interest)

  • Key (user_idx) — int — Foreign key → Untitled.Key — NOT NULL — unique with interest_idx
  • Key (interest_idx) — int — Foreign key → Untitled.Key — NOT NULL — unique with user_idx
  • Field (created_at) — timestamp — NOT NULL

Untitled (ask_category)

  • Key (idx) — int — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (is_deleted) — boolean — NOT NULL

Untitled (import_notification)

  • Field (user_idx) — 누가
  • Field2 (type) — 중요알림
  • Field (interest) — lck
  • Field (content) — t1 vs genG
  • Field (id_read)

Untitled (manager_notification)

  • Field (user_idx) — 누가
  • Field (type) — 관심사 알림
  • Field (interest) — lck
  • Field2 (is_read)

Untitled (reply_notification)

  • Field (user_idx) — 누가
  • Field (type) — 답변 알림
  • Field (title) — 사용자 작성 제목
  • Field (reply) — 답변
  • Field2 (is_read)

Untitled (manager)

  • Key (user_idx) — int — Foreign key → Untitled.Key — NOT NULL — unique
  • Key (interest_idx) — int — Foreign key → Untitled.Key — NOT NULL — unique

Untitled (login)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Field (id) — varchar — NOT NULL
  • Field (pw) — varchar — NOT NULL

Untitled (kakao)

  • Key (idx) — int — Primary key — NOT NULL — auto increament
  • Field (id) — bigint — NOT NULL

Untitled (logging)

  • Field (user_idx) — int — 누가
  • Field (api) — 어떤 api
  • Field (time) — 언제
  • Field (req) — 요청
  • Field (res) — 응답 상태코드

Untitled (interest_priority)

  • Key (idx) — int — Primary key — NOT NULL — auto Increament
  • Key (user_idx) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (interest_schedule_idx) — int — Foreign key → Untitled.Key — NOT NULL