ㅂ
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)