Bank

Tables (6)

BANKBOOK (통장)

  • BOOKNUM (통장일련번호) — Number — Primary key — NOT NULL
  • BOOKNAME (통장이름) — varchar2(200)
  • BOOKRATE (이자율) — Number(4,2)
  • BOOKSALE (판매여부) — Number(1)

BB_Comment (뱅그북댓글)

  • NUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • BOOKNUM (통장일련번호) — Number — Foreign key → BANKBOOK.BOOKNUM — NOT NULL
  • writer (댓글작성자) — varchar2(200)
  • CONTENTS (댓글내용) — VARCHAR2(4000)
  • REGDATE (댓글작성날자) — Date

BankMembers (회원)

  • USERNAME (회원의 ID) — Varchar2(200) — Primary key — NOT NULL
  • PASSWORD' (비번) — varchar2(200)
  • NAME (이름) — varchar2(200)
  • Email (이메일) — varchar2(200)]
  • Phone (전화번호) — varchar2(200)

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

MemberFile (회원의photo정보)

  • FILENUM (파일번호) — Number — Primary key — NOT NULL
  • USERNAME (회원의 ID) — Varchar2(200) — Foreign key → BankMembers.USERNAME — NOT NULL
  • FILENAME (저장된파일명) — varchar2(400)
  • oriName (upload시 파일명) — varchar2(200)

Role (회원등급)

  • RoleNum (일련번호) — Number — Primary key — NOT NULL
  • RoleName (등급이름) — varchar2(200)