test1
Tables (11)
bcomment
- reno — number — Primary key — NOT NULL
- recontent — varchar2(500)
- redate — date
- 게시판종류 (type) — varchar2(50) — NOT NULL
- 게시판번호 (no) — number — NOT NULL
- 댓글작성자 (wirter) — NOT NULL
board
- boardno (defno) — number — Primary key — NOT NULL
- title — varchar2(500)
- content — varchar2(2000) — NOT NULL
- boardfile (deffile) — varchar2(50) — NOT NULL
- boarddate (defdate) — date
- state — varchar2(50)
- 글쓴이 (wirter) — varchar2(50)
- 게시판종류 (type) — varchar2(50)
calendar
- calendarno — number — Primary key — NOT NULL
- caltitle — varchar2(500)
- calcontent — varchar2(2000)
- startdate — date
- enddate — date
- 글쓴이 (wirter) — varchar2(50)
car
- carnum — varchar2(50) — Primary key — NOT NULL
- cartype — varchar2(50)
- id — varchar2(50) — Foreign key → resident.id — NOT NULL
fitness
- id — varchar2(50) — Foreign key → resident.id — NOT NULL
- startdate — date
- enddate — date
- cost — varchar2(50)
- 결제시간 (paydate) — date
library
- id — varchar2(50) — Foreign key → resident.id — NOT NULL
- seat — number
- startdate — date
- enddate — date
- cost — varchar2(50)
- 결제시간 (paydate) — date
manager
- mid — varchar2(50) — Primary key — NOT NULL
- password — varchar2(50)
- name — varchar2(50)
- birth — date
- king — varchar2(50) — NOT NULL
payment
- payid — number — Primary key — NOT NULL
- cost — varchar2(50)
- paydate — date
- status — varchar2(50)
- id — varchar2(50) — Foreign key → resident.id — NOT NULL
- paymonth — date
- delaytax — varchar2(50)
postbox
- postno — number — Primary key — NOT NULL
- product — varchar2(50)
- get — varchar2(50)
- gettime — date
- id — varchar2(50) — Foreign key → resident.id — NOT NULL
- 택배도착시간 (arrivedate) — date
resident
- id — varchar2(50) — Primary key — NOT NULL
- password — varchar2(50)
- name — varchar2(50)
- phone — varchar2(50)
- birth — date
- owner — varchar2(50) — Foreign key → resident.id
- auth — varchar2(50)
- 동 (dong) — varchar2(50)
- 호수 (ho) — varchar2(50)
- 탈퇴여부확인 (del) — varchar2(50)
visitcar
- carnum — varchar2(50) — Primary key — NOT NULL
- purpose — varchar2(50)
- startdate — date
- enddate — date
- id — varchar2(50) — Foreign key → resident.id — NOT NULL