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