yaeji

Tables (7)

book (예약)

  • book_id (예약id) — Primary key — NOT NULL
  • facilities_id (시설id) — Foreign key → facilities.facilities_id — NOT NULL
  • householder_id (세대주 id) — Foreign key → householder.householder_id — NOT NULL
  • reg_date (예약일자)
  • state (승인여부)

complaints (민원)

  • complaints_id (민원 id) — Primary key — NOT NULL
  • enroll_date (작성일자)
  • content (내용)
  • attachment_url (첨부파일 url)
  • state (상태)
  • householder_id (세대주 id) — Foreign key → householder.householder_id — NOT NULL

facilities (시설)

  • facilities_id (시설id) — Primary key — NOT NULL
  • name (시설이름)
  • locate (위치)
  • time_available (이용가능시간)

household_info (세대 정보)

  • household_id (세대 id) — Primary key — NOT NULL
  • info (세대정보)
  • householder_id (세대주 id) — Foreign key → householder.householder_id — NOT NULL
  • locate (거주기록)

householder (세대주)

  • householder_id (세대주 id) — Primary key — NOT NULL
  • profile_url (프로필사진)
  • user_id (사용자 id) — Foreign key → user.user_id — NOT NULL

notice (공지사항)

  • notice_id (공지사항 id) — Primary key — NOT NULL
  • attachment_url (첨부파일 url)
  • complaints_id (민원 id) — Foreign key → complaints.complaints_id — NOT NULL
  • title (제목)
  • reg_date (작성일자)

user (사용자)

  • user_id (사용자 id) — Primary key — NOT NULL
  • id
  • pw
  • authority (권한)