ㅂ

Tables (7)

DateCockBusinessInput

  • businessnumber — varchar2(70) — Foreign key → DateCockBusinessMember.businessnumber — NOT NULL
  • businessname — varchar2(100)
  • address — varchar2(130)
  • businesstime — varchar2(80)
  • phone — varchar2(100)
  • image — varchar2(250)
  • information — varchar2(3000)
  • age — number(7)
  • zone — varchar2(100)
  • activity — varchar2(40)

DateCockBusinessLogin

  • businessnumber — varchar2(70) — Foreign key → DateCockBusinessMember.businessnumber — NOT NULL
  • password — varchar2(100)

DateCockBusinessMember

  • businessnumber — varchar2(70) — Primary key — NOT NULL
  • password — varchar2(100)
  • email — varchar2(100)
  • businessname — varchar2(40)
  • phone — varchar2(100)
  • birthyear — varchar2(100)

DateCockGuest

  • id — varchar2(70) — Foreign key → DateCockMember.id — NOT NULL
  • name — varchar2(30)
  • memo — varchar2(500)
  • todays — date

DateCockLogin

  • id — varchar2(70) — Foreign key → DateCockMember.id — NOT NULL
  • password — varchar2(100)

DateCockMember

  • id — varchar2(70) — Primary key — NOT NULL
  • password — varchar2(100)
  • email — varchar2(100)
  • name — varchar2(30)
  • birthyear — varchar2(100)
  • phone — varchar2(100)

DateCockReservation

  • id — varchar2(70) — Foreign key → DateCockMember.id — NOT NULL
  • name — varchar2(30) — NOT NULL
  • phone — varchar2(100)
  • day — date
  • intime — varchar2(60)