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