skilweaver
Tables (10)
learning_goal
- learning_goal_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- due_date — DATE
- priority — VARCHAR(20) — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- target_track — VARCHAR(20) — NOT NULL
- experience_level — VARCHAR(20) — NOT NULL
- daily_minutes — INT — NOT NULL
- prefer_korean — TINYINT(1) — NOT NULL
- learning_style — VARCHAR(20) — NOT NULL
- weekend_boost — TINYINT(1) — NOT NULL
member_skill
- member_skill_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- technology_id — BIGINT
- custom_name — VARCHAR(100)
- level — VARCHAR(50) — NOT NULL
- years_of_use — DOUBLE — NOT NULL
- last_used_at — DATE
- note — TEXT
tech_prerequisite
- tech_prerequisite_id — BIGINT — Primary key — NOT NULL
- knowledge_id — BIGINT — NOT NULL
- prerequisite_key — VARCHAR(100) — NOT NULL
tech_relationship
- tech_relationship_id — BIGINT — Primary key — NOT NULL
- from_id — BIGINT — NOT NULL
- to_id — BIGINT — NOT NULL
- relation_type — VARCHAR(20) — NOT NULL
- weight — INT — NOT NULL
tech_use_case
- tech_use_case_id — BIGINT — Primary key — NOT NULL
- knowledge_id — BIGINT — NOT NULL
- use_case — VARCHAR(255) — NOT NULL
technology
- technology_id — BIGINT — Primary key — NOT NULL
- key — VARCHAR(100) — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- ecosystem — VARCHAR(100)
- official_site — VARCHAR(255)
- active — TINYINT(1) — NOT NULL
technology_edit
- technology_edit_id — BIGINT — Primary key — NOT NULL
- technology_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- proposed_summary — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
technology_edit_prerequisite
- technology_edit_prerequisite_id — BIGINT — Primary key — NOT NULL
- edit_id — BIGINT — NOT NULL
- prerequisite — VARCHAR(100) — NOT NULL
technology_knowledge
- technology_knowledge_id — BIGINT — Primary key — NOT NULL
- technology_id — BIGINT — NOT NULL
- summary — TEXT
- learning_tips — TEXT
- source_type — VARCHAR(20) — NOT NULL