hackathon

Tables (19)

CATEGORIES (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • parent_id (FK)
  • name (Field2)
  • depth (Field3)

CHAT_MESSAGES (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • chat_room_id (Key2) — Foreign key → CHAT_ROOMS.id — NOT NULL
  • sender_id (PK3) — Foreign key → Member.id — NOT NULL
  • content (Field2)

CHAT_ROOMS (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • room_type (Field)
  • reference_id (Field2)

CHAT_ROOM_MEMBERS (Untitled19)

  • id (Key) — Primary key — NOT NULL
  • member_id (PK) — Foreign key → Member.id — NOT NULL
  • chat_rooms_id (Key2) — Foreign key → CHAT_ROOMS.id — NOT NULL
  • role (Field)
  • joined_at (Field2)
  • left_at (Field3)

GIKBTI_OPTIONS (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • gikbti_questions_id (Key2) — Foreign key → GIKBTI_QUESTIONS.id — NOT NULL
  • text (Field)
  • is_true (Field2)
  • display_order (Field3)

GIKBTI_QUESTIONS (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • category (Field)
  • text (Field2)
  • is_active (Field3)
  • display_order (Field4) — int

GROUPBUYS (Untitled17)

  • id (Key) — Primary key — NOT NULL
  • category_id (FK1) — Foreign key → CATEGORIES.id — NOT NULL
  • member_id (FK2) — Foreign key → Member.id — NOT NULL
  • title (Field)
  • description (Field2)
  • current_count (Field3)
  • target_count (Field4)
  • status (Field5)

GROUPBUY_MEMBERS (Untitled18)

  • id (Key) — Primary key — NOT NULL
  • member_id (PK) — Foreign key → Member.id — NOT NULL
  • groupbuys_id (Key2) — Foreign key → GROUPBUYS.id — NOT NULL
  • category_id (FK1) — Foreign key → GROUPBUYS.category_id — NOT NULL
  • member_id (FK2) — Foreign key → GROUPBUYS.member_id — NOT NULL
  • role (Field)
  • status (Field2)
  • joined_at (Field3)
  • left_at (Field4)

LAUNDRY_CONGESTION_FORECAST (Untitled15)

  • id (Key) — Primary key — NOT NULL
  • week (Field) — enum
  • hour (Field2)
  • gender_zone (Field3)
  • congestion (Field4)

LAUNDRY_MACHINES (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • type (Field)
  • gender_zone (Field2)
  • machine_number (Field3)
  • status (Field4)
  • remaining_seconds (Field5)

LAUNDRY_SESSIONS (Untitled14)

  • id (Key2) — Primary key — NOT NULL
  • laundry_machines_id (Key) — Foreign key → LAUNDRY_MACHINES.id — NOT NULL
  • member_id (PK) — Foreign key → Member.id — NOT NULL
  • status (Field)
  • started_at (Field2)
  • end_at (Field3)

MATCH_PAIRS (Untitled7)

  • Id (Key) — Primary key — NOT NULL
  • member1_id (PK) — Foreign key → Member.id — NOT NULL
  • member2_id (PK2) — Foreign key → Member.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

MATCH_REQUEST (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • match_pairs_id (Key2) — Foreign key → MATCH_PAIRS.Id — NOT NULL
  • member1_id (PK) — Foreign key → MATCH_PAIRS.member1_id — NOT NULL
  • member2_id (PK2) — Foreign key → MATCH_PAIRS.member2_id — NOT NULL
  • sender_id (PK3) — Foreign key → Member.id — NOT NULL
  • status (Field2)

Member (Untitled)

  • id (PK) — Primary key — NOT NULL
  • student_id (Field)
  • major (Field3)
  • grade (Field4)
  • completed_semester (Field5)
  • status (Field6)
  • gender (Field7)
  • birth_date (Field8)
  • is_smoker (Field9)
  • is_drinker (Field10)
  • gikbti (Field2)

NOTICES (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • image_url (Field3)

PICKS (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • from_member_id (FK1) — Foreign key → Member.id — NOT NULL
  • to_member_id (FK2) — Foreign key → Member.id — NOT NULL

ROOMMATE_MATCHES (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • pair_id (Key2) — Foreign key → MATCH_PAIRS.Id — NOT NULL
  • member1_id (PK) — Foreign key → MATCH_PAIRS.member1_id — NOT NULL
  • member2_id (PK2) — Foreign key → MATCH_PAIRS.member2_id — NOT NULL
  • status (Field)
  • completed_at (Field2)

USER_GIKBTI_ANSWERS (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • member_id (FK1) — Foreign key → Member.id — NOT NULL
  • gikbti_optinos_id (FK2) — Foreign key → GIKBTI_OPTIONS.id — NOT NULL
  • gikbti_questions_id (FK3) — Foreign key → GIKBTI_OPTIONS.gikbti_questions_id — NOT NULL

user_preferences (Untitled2)

  • id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.id — NOT NULL
  • roommate_smoking_pref (Field)
  • roommate_drinking_pref (Field2)