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)