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