bank

Tables (6)

BANKMEMBERS (회원)

  • USER_NAME (Key) — VARCHAR2(200) — Primary key — NOT NULL
  • PASSWORD (Field) — VARCHAR2(200)
  • NAME (Field2) — VARCHAR2(200)
  • EMAIL (Field3) — VARCHAR2(200)
  • PHONE (Field4) — VARCHAR2(200)

BankBook (뱅크북)

  • BOOKNUM (뱅크북 번호) — NUMBER — Primary key — NOT NULL
  • BOOKNAME (이름) — VARCHAR2(200)
  • BOOKRATE (이자율) — NUMBER(4,1)
  • BOOKSALE (판매여부) — NUMBER(1)

Comment (뱅크북 댓글)

  • NUM (댓글의 번호) — NUMBER — Primary key — NOT NULL
  • BOOKNUM (뱅크북 번호) — NUMBER — Foreign key → BankBook.BOOKNUM — NOT NULL
  • WRITER (댓글의 작성자) — VARCHAR2(200)
  • REGDATE (댓글의 작성날짜) — DATE
  • CONTENTS (댓글내용) — VARCHAR2(4000)

MEMBERFILE (Untitled)

  • FILENUM (Key) — NUMBER — Primary key — NOT NULL
  • USER_NAME (Key2) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USER_NAME — NOT NULL
  • FILENAME (Field) — VARCHAR2(400)
  • ORINAME (Field2) — VARCHAR2(400)

MEMBER_ROLE (등급)

  • NUM (식별) — NUMBER — Primary key — NOT NULL
  • USER_NAME (Key) — VARCHAR2(200) — Foreign key → BANKMEMBERS.USER_NAME — NOT NULL
  • RoleNum (일련번호) — Number — Foreign key → ROLL.RoleNum — NOT NULL

ROLL (회원등급)

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