achieve

Tables (5)

Comment

  • 댓글_아이디 (suggestionComment_id) — PK — Primary key — NOT NULL
  • 게시글_아이디 (board_id) — FK — Foreign key → Suggestion.게시글_아이디 — NOT NULL
  • 내용 (context) — NOTNULL
  • 생성날짜 (created_at) — NULL
  • 수정날짜 (updated_at) — NULL
  • 삭제날짜 (deleted_at) — NULL

Reservation (Untitled2)

  • 예약_아이디 (reservation_id) — PK — Primary key — NOT NULL
  • 방_아이디 (Key) — pk — Foreign key → meeting_room.방_아이디 — NOT NULL
  • 이메일 (email) — NOTNULL
  • 예약시간 (time) — NOTNULL
  • 인원 (members) — NOTNULL
  • 생성날짜 (created_at) — NULL
  • 수정날짜 (updated_at) — NULL
  • 삭제날짜 (deleted_at) — NULL

Suggestion

  • 게시글_아이디 (board_id) — PK — Primary key — NOT NULL
  • 제목 (titel) — NOTNULL
  • 내용 (context) — NOTNULL
  • 조회수 (views) — NOTNULL
  • 카테고리 (category) — NOTNULL
  • 생성날짜 (created_at) — NULL
  • 수정날짜 (updated_at) — NULL
  • 삭제날짜 (deleted_at) — NULL

category (Untitled3)

  • suggestion (Field)
  • notification (Field2)

meeting_room

  • 방_아이디 (Key) — pk — Primary key — NOT NULL
  • 예약가능여부 (is_activated) — NOTNULL