ㅎㄹㅇㄴㅎㄹㄴㅇ

Tables (4)

Interests

  • interest_id — BIGINT(32) — Primary key — NOT NULL
  • interest_name — VARCHAR(10) — NOT NULL

Notifications

  • notification_id — BIGINT(32) — Primary key — NOT NULL
  • noti_message — VARCHAR(100)
  • noti_created_at — DATETIME — NOT NULL

User_Interests

  • user_id — BIGINT(32) — Primary key — NOT NULL
  • interest_id — BIGINT(32) — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT(32) — Foreign key → Users.user_id — NOT NULL
  • interest_id (interest_id2) — BIGINT(32) — Foreign key → Interests.interest_id — NOT NULL

Users

  • user_id — BIGINT(32) — Primary key — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(8) — NOT NULL
  • gender — INT — NOT NULL
  • birth_date — VARCHAR(50) — NOT NULL
  • authority — INT — NOT NULL
  • mobile_number — VARCHAR(20) — NOT NULL
  • province — VARCHAR(50)
  • city — VARCHAR(50)