12기 중앙 해커톤

테이블 (9)

Calender (Untitled3)

  • Event_id (Key) — 기본 키 — NOT NULL
  • User_id (Key2) — 외래 키 → User.User_id — NOT NULL
  • Title (Field)
  • Description (Field2)
  • Start_time (Field3)
  • End_time (Field4)
  • Location (Field5)
  • Create_at (Field6)
  • Modified_at (Field7)

Chat (Untitled4)

  • Chat_id (Key) — 기본 키 — NOT NULL
  • User_id (Key2) — 외래 키 → User.User_id — NOT NULL
  • Message (Field)
  • Crate_At (Field2)
  • Send_At (Field3)
  • Send_Time (Field4)

Comment (Untitled7)

  • Comment_id (Key) — 기본 키 — NOT NULL
  • Post_id (Key2) — 외래 키 → Community.Post_id — NOT NULL
  • User_id (Key3) — 외래 키 → User.User_id — NOT NULL
  • Content (Field)
  • Create_at (Field2)
  • Modified_at (Field3)

Community (Untitled5)

  • Post_id (Key) — 기본 키 — NOT NULL
  • User_id (Key2) — 외래 키 → User.User_id — NOT NULL
  • Content (Field)
  • Create_At (Field2)
  • Create_Time (Field4)
  • Modified_Time (Field3)

EventReminder (Untitled9)

  • Reminder_id (Key) — 기본 키 — NOT NULL
  • Event_id (Key2) — 외래 키 → Calender.Event_id — NOT NULL
  • Reminder_time (Field)
  • Create_at (Field2)

GroupChat (Untitled2)

  • Group_id (Key) — 기본 키 — NOT NULL
  • User_id (Key2) — 외래 키 → User.User_id — NOT NULL
  • Message (Field)
  • Send_at (Field2)

GroupMember (Untitled8)

  • Group_member_id (Key) — 기본 키 — NOT NULL
  • Group_id (Key3) — 외래 키 → GroupChat.Group_id — NOT NULL
  • User_id (Key22) — 외래 키 → GroupChat.User_id — NOT NULL

Matching (Untitled6)

  • Matching_id (Key) — 기본 키 — NOT NULL
  • User_id (Key2) — 외래 키 → User.User_id — NOT NULL
  • Matching_Type (Field)
  • Create_At (Field2)

User (Untitled)

  • User_id (Key) — 기본 키 — NOT NULL
  • Username (Field10)
  • Email (Field8)
  • Password (Field9)
  • Comp_Name (Field)
  • Part (Field2)
  • Career (Field3)
  • Comp_auth (Field4)
  • Gender (Field5)
  • Chatroom (Field6)
  • Maching_History (Field7)