HY-Uni
Tables (7)
attribute
- attribute_id — BIGINT
- name — VARCHAR(100) — NOT NULL
interest
- interest_id — BIGINT
- name — VARCHAR(100) — NOT NULL
keyword
- keyword_id — BIGINT
- name — VARCHAR(100) — NOT NULL
user
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE — NOT NULL
- student_number — VARCHAR(20) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- department_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_attribute
- user_id — BIGINT — Primary key — NOT NULL
- attribute_id — BIGINT — Primary key — NOT NULL
user_interest
- user_id — BIGINT — Primary key — NOT NULL
- interest_id — BIGINT — Primary key — NOT NULL
user_keyword
- user_id — BIGINT — Primary key — NOT NULL
- keyword_id — BIGINT — Primary key — NOT NULL