에브리타임
테이블 (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