Bank

Tables (6)

BankBook (통장)

  • BOOKNUM (통장일련번호) — NUMBER — Primary key — NOT NULL
  • BOOKNAME (통장이름) — VARCHAR2(200)
  • BOOKRATE (통장이자율) — NUMBER(4.2)
  • BOOKSALE (통장판매여부) — NUMBER(1)

BankMembers (회원)

  • USERNAME (회원의 ID) — VARCHAR2(200) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)
  • PHONE (전화번호) — VARCHAR2(200)

Comment (bank댓글)

  • Key (댓글번호) — NUMBER — Primary key — NOT NULL
  • BOOKNUM (통장일련번호) — NUMBER — Foreign key → BankBook.BOOKNUM — NOT NULL
  • WRITER (댓글작성자) — VARCHAR2(200)
  • CONTENTS (댓글내용) — VARCHAR2(40000)
  • REGDATE (댓글작성일) — DATE

MemberFile (회원의 사진정보)

  • FILENUM (파일번호) — NUMBER — Primary key — NOT NULL
  • USERNAME (회원의 ID) — VARCHAR2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
  • FILENAME (파일명) — VARCHAR2(400)
  • ORINAME (업로드시 파일명)

Member_Role (등급)

  • NUM (식별용도) — NUMBER — Primary key — NOT NULL
  • USERNAME (회원의 ID) — VARCHAR2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
  • ROLENUM (일련번호) — NUMBER — Foreign key → Role.ROLENUM — NOT NULL

Role (회원등급)

  • ROLENUM (일련번호) — NUMBER — Primary key — NOT NULL
  • ROLENAME (등급이름)