JoA
Tables (14)
Block
- Block_id — SERIAL
- blocker_id — BIGINT
- blocked_id — BIGINT
Heart
- Heart_id — bigint — Primary key — NOT NULL
- Give_id — bigint — NOT NULL
- Take_id — bigint — Foreign key → Member.Member_id — NOT NULL
- date — datetime(6) — NOT NULL
Location
- Member_id — BIGINT
- College_id — BIGINT
- Member_point — geometry(PointZ, 4326)
- Is_contained — BOOLEAN
- Update_date — TIMESTAMP
M_college
- M_college_id — bigint — Primary key — NOT NULL
- domain — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
Member
- Member_id — bigint — Primary key — NOT NULL
- Is_withdrawal — bit(1) — NOT NULL
- Report_count — int — NOT NULL
- College_id — bigint — Foreign key → M_college.M_college_id
- Session_id — bigint
- Stop_end_date — datetime(6)
- Stop_start_date — datetime(6)
- bio — varchar(15) — NOT NULL
- Login_id — varchar(255) — NOT NULL
- U_email — varchar(255) — NOT NULL
- Url_code — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- salt — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- Fcm_token — varchar(255) — NOT NULL
Message
- Message_id — bigint — Primary key — NOT NULL
- Member_id — bigint — Foreign key → Member.Member_id — NOT NULL
- Room_id — bigint — Foreign key → Room.Room_id — NOT NULL
- time — datetime(6) — NOT NULL
- content — varchar(255) — NOT NULL
- isChecked — varchar(255) — NOT NULL
Message_report
- MReport_id — bigint — Primary key — NOT NULL
- Category_id — bigint — Foreign key → Report_category.Report_category_id — NOT NULL
- Message_Id — bigint — Foreign key → Message.Message_id
- date — datetime(6) — NOT NULL
- content — varchar(255)
P_college
- P_college_id — BIGINT
- Polygon_field — geometry(Polygon, 4326) — NOT NULL
Report_category
- Report_category_id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
Room
- Room_id — bigint — Primary key — NOT NULL
- date — datetime(6) — NOT NULL
- encryptKey — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
Room_in_member
- Room_id — bigint — Foreign key → Room.Room_id — NOT NULL
- Member_id — bigint — Foreign key → Member.Member_id — NOT NULL
- Entry_time — datetime(6)
- Exit_time — datetime(6)
- expired — varchar(255) — NOT NULL
- result — varchar(255) — NOT NULL
Vote
- Vote_id — bigint — Primary key — NOT NULL
- Is_valid — bit(1) — NOT NULL
- Category_id — bigint — Foreign key → Vote_category.Vote_category_id — NOT NULL
- Give_id — bigint — NOT NULL
- Take_id — bigint — Foreign key → Member.Member_id — NOT NULL
- date — datetime(6) — NOT NULL
- hint — varchar(255)
Vote_category
- Vote_category_id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
Vote_report
- Vote_report_id — bigint — Primary key — NOT NULL
- Report_Category_id — bigint — Foreign key → Report_category.Report_category_id — NOT NULL
- Vote_id — bigint — Foreign key → Vote.Vote_id — NOT NULL
- date — datetime(6) — NOT NULL
- content — varchar(255)