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 — 관리자 여부