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)