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 (뱅크북댓글)

  • Num (댓글번호) — Number — Primary key — NOT NULL
  • BookNum (통장일련번호) — Number — Foreign key → BankBook.BookNum — NOT NULL
  • Writer (댓글작성자) — varchar2(200)
  • Contents (댓글내용) — varchar(40000)
  • RegDate (댓글작성날짜) — Date

MemberFile (회원사진정보)

  • FILENUM (파일번호) — Number — Primary key — NOT NULL
  • USERNAME (회원ID) — Varchar2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
  • FILENAME (파일이름) — Varchar2(200)
  • ORINAME (업로드명) — Varchar2(200)

MemberRole (등급)

  • 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 (등급이름) — Varchar2(200)