9roomUniv

Tables (11)

BLINDDATE

  • blind_date_id — INT — Primary key
  • user2_id (user_id) — INT — Foreign key → USER.user_id
  • user1_id (user_id2) — INT — Foreign key → USER.user_id
  • created_at — TIMESTAMP
  • chat_limit — INT

BLINDDATECHAT

  • message_id — INT — Primary key
  • blind_date_id — INT — Foreign key → BLINDDATE.blind_date_id
  • user_id — INT — Foreign key → USER.user_id
  • message — TEXT
  • timestamp — TIMESTAMP
  • read_status — BOOLEAN

BLOCK

  • block_id — INT — Primary key
  • blocker_id — INT — NOT NULL
  • blocked_id — INT — NOT NULL
  • created_at — TIMESTAMP

MEETING

  • meeting_id — INT — Primary key
  • created_by — INT — NOT NULL
  • meeting_time — TIMESTAMP — NOT NULL
  • meeting_details — TEXT

MEETINGCHAT

  • message_id — INT — Primary key
  • meeting_id — INT — Foreign key → MEETING.meeting_id
  • sender_id — INT — NOT NULL
  • message — TEXT
  • timestamp — TIMESTAMP

MEETINGPARTICIPANT

  • meeting_id — INT — Primary key — NOT NULL
  • user_id (user_id2) — INT — Foreign key → USER.user_id
  • read_status — BOOLEAN

PAYMENT

  • payment_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → USER.user_id
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • transaction_date — TIMESTAMP
  • description — TEXT

REPORT

  • report_id — INT — Primary key
  • reporter_id — INT — NOT NULL
  • reported_id — INT — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMP
  • reward_flag — BOOLEAN

SCHOOL

  • school_id — INT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • domain — VARCHAR(255) — NOT NULL

USER

  • user_id — INT — Primary key
  • school_id — INT — Foreign key → SCHOOL.school_id
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • image — VARCHAR(255)
  • height — INT
  • age — INT
  • biography — TEXT
  • major — VARCHAR(100)
  • email_verified — BOOLEAN

USERPREFERENCE

  • preference_id — INT — Primary key
  • user_id — INT — Foreign key → USER.user_id
  • desired_age_min — INT
  • desired_age_max — INT
  • desired_height_min — INT
  • desired_height_max — INT
  • desired_school — VARCHAR(255)
  • desired_major — VARCHAR(255)
  • additional_criteria — TEXT