TeleGuest
Tables (5)
GuestHouse (Untitled3)
- id — integer — Primary key — NOT NULL
- name — varchar2(50) — NOT NULL
- description — varchar2(1000)
- address — varchar2(100) — NOT NULL
- phone — varchar2(13)
- created_date — datetimefield — NOT NULL
Party (Untitled2)
- id — integer — Primary key — NOT NULL
- owner — integer — Foreign key → User.id — NOT NULL
- title — varchar2(100) — NOT NULL
- date — datefield — NOT NULL
- description — varchar2(1000)
- capacity — integer — NOT NULL
- num_of_people (Field6) — integer — NOT NULL
- pub_date — datetimefield — NOT NULL
Room (Untitled6)
- id — integer — Primary key — NOT NULL
- name — varchar2(20) — NOT NULL
- max — integer — NOT NULL
- price — integer — NOT NULL
- guesthouse — integer — Foreign key → GuestHouse.id — NOT NULL
RoomPeople (Untitled5)
- id — integer — Primary key — NOT NULL
- user — integer — Foreign key → User.id — NOT NULL
- room — integer — Foreign key → Room.id — NOT NULL
User (Untitled)
- id — integer — Primary key — NOT NULL
- email — varchar2(50) — NOT NULL — 로그인시 사용, unique
- nickname — varchar2(20)
- password — varchar2(20) — NOT NULL — 비밀번호
- phone — varchar2(13)
- is_active — boolean — NOT NULL
- is_admin — boolean — 관리자 여부