ㄴㅁㅇㄹㅁㄴㅇㄹ

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

    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)