Bank

Tables (6)

BankBook (통장)

  • BookNum (일련번호) — Number — Primary key — NOT NULL
  • BookName (통장 이름) — varchar2(200)
  • BookRate (이자율) — Number(4, 2)
  • BookSale (통장 판매 여부) — Number(1)

Comment (BankBook댓글)

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

Role (회원등급)

  • RoleNum (Key) — number — Primary key — NOT NULL
  • Rolename (Field) — varchar2(200)
  • Field2

memberFiles (회원의 이미지 정보)

  • fileNum (Key) — number — Primary key — NOT NULL
  • username (Key2) — Foreign key → memebers.username — NOT NULL
  • filename (Field) — varchar2(400)
  • oriname (Field2) — varchar2(200)
  • Field3

member_role (등급)

  • num (Key) — number — Primary key — NOT NULL
  • username (Key2) — Foreign key → memebers.username — NOT NULL
  • RoleNum (Key3) — number — Foreign key → Role.RoleNum — NOT NULL

memebers (Untitled)

  • username (Key) — Primary key — NOT NULL
  • password (Field)
  • name (Field2)
  • email (Field3)
  • phone (Field4)
  • Field5