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 (권한)