에브리타임

테이블 (13)

Attachment (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • storedFileName (Field2) — varchar(255)
  • originalFileName (Field3) — varchar(255)
  • attachment_type (Field4) — enum('IMAGE','GENERAL')
  • post_id (Key2) — bigint — 외래 키 → Post.post_id — NOT NULL

Board (Untitled14)

  • board_id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(100)
  • school_id (Key2) — bigint — 외래 키 → School.school_id — NOT NULL

ChattingRoom (Untitled16)

  • chatting_room_id (Key) — bigint — 기본 키 — NOT NULL
  • Field
  • participant1_id (Key2) — bigint — 외래 키 → User.user_id — NOT NULL
  • participant2_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL

ClassTime (Untitled13)

  • class_time_id (Key2) — bigint — 기본 키 — NOT NULL
  • dayOfWeek (Key) — enum("MON", "TUE", "WED", "THU", "FRI", "SAT", "SUN") — NOT NULL
  • timePeriod (Field) — int
  • course_number (Key3) — varchar(255) — 외래 키 → Course.course_id — NOT NULL

Comment (Untitled19)

  • comment_id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field) — varchar(1000)
  • createDate (Field2) — DateTime
  • modifiedDate (Field3) — DateTime
  • post_id (Key2) — bigint — 외래 키 → Post.post_id — NOT NULL
  • user_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
  • parent_comment_id (Key4) — bigint — 외래 키 → Comment.comment_id — NOT NULL

Course (Untitled11)

  • course_id (Key) — varchar(255) — 기본 키 — NOT NULL
  • name (Field2) — varchar(30)
  • openingGrade (Field) — int
  • professorName (Field3) — varchar(50)
  • credit (Field4) — int
  • room (Field5) — varchar(50)
  • school_id (Key2) — bigint — 외래 키 → School.school_id — NOT NULL

Post (Untitled15)

  • post_id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — varchar(1000)
  • isQuestion (Field3) — bool
  • isAnonymous (Field4) — bool
  • createdDate (Field5) — DateTime
  • modifiedDate (Field6) — DateTime
  • user_id (Key2) — bigint — 외래 키 → User.user_id — NOT NULL
  • board_id (Key3) — bigint — 외래 키 → Board.board_id — NOT NULL

PostLike (Untitled20)

  • post_like_id (Key) — bigint — 기본 키 — NOT NULL
  • post_id (Key2) — bigint — 외래 키 → Post.post_id — NOT NULL
  • user_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL

School (Untitled12)

  • school_id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(15)

TimeTable (Untitled10)

  • time_table_id (Key) — bigInt — 기본 키 — NOT NULL
  • semester (Field) — enum('FIRST','SECOND','SUMMER','WINTER')
  • name (Field2) — varchar(50)
  • year (Field5) — int
  • createdDate (Field3) — DateTime
  • modifiedDate (Field4) — DateTime
  • user_id (Key2) — bigInt — 외래 키 → User.user_id — NOT NULL

TimeTableCourse (Untitled)

  • time_table_course_id (Key) — Long — 기본 키 — NOT NULL
  • Field
  • time_table_id (Key2) — bigInt — 외래 키 → TimeTable.time_table_id — NOT NULL
  • course_id (Key3) — varchar(255) — 외래 키 → Course.course_id — NOT NULL

User (Untitled9)

  • user_id (Key) — bigint — 기본 키 — NOT NULL
  • username (Field) — varchar(50)
  • password (Field2) — varchar(50)
  • email (Field3) — varchar(50)
  • name (Field4) — varchar(20)
  • studentNo (Field5) — varchar(20)
  • school_id (Key2) — bigint — 외래 키 → School.school_id — NOT NULL

chat (Untitled18)

  • chat_id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field4) — varchar(1000)
  • sentAt (Field) — DateTime
  • author_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
  • chatting_room_id (Key2) — bigint — 외래 키 → ChattingRoom.chatting_room_id — NOT NULL