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