최종

테이블 (9)

DragonInfo

  • userId, dragonId — varchar2(50), number(10) — 기본 키 — NOT NULL
  • userId — varchar2(50) — 외래 키 → Member.userId
  • totalLevel — number(3)
  • levelValue — number(3)
  • foodValue — number(3)
  • toyValue — number(3)
  • equip — varchar2(1)
  • backgroundId — number

Folder

  • folderId — number — 기본 키 — NOT NULL
  • userId — varchar2(50) — 외래 키 → Member.userId
  • folderTitle — varchar2(100) — unique
  • description — varchar2(200)
  • link — varchar2(200)
  • regDate — Date

Inventory

  • inventoryId — varchar2(50) — 기본 키 — NOT NULL
  • userId — varchar2(50) — 외래 키 → Member.userId
  • productId — number — 외래 키 → Product.productId — NOT NULL
  • amount — number
  • orderDate — Date

Member

  • userId — varchar2(50) — 기본 키
  • userPassword (userPwd) — varchar2(50)
  • userName — varchar2(50)
  • birthday — varchar2(50)
  • phoneNumber (phoneNo) — varchar2(50)
  • email — varchar2(50)
  • lastConnection (lastConn) — Date
  • enabled — char(1)

Persistent_logins

  • userName — varchar2(50) — 외래 키 → Member.userId
  • series — varchar2(64)
  • token — varchar2(64)
  • last_used — timeStamp

Product

  • productId (proId) — number — 기본 키 — NOT NULL
  • productName (proName) — nvarchar2(40)
  • productImage (proImg) — nvarchar2(70)
  • price — number
  • category — nvarchar2(30)
  • description — nvarchar2(200)

recentStudy

  • bookTitle — varchar2(50)
  • studyDate — Date
  • bookId — number — 외래 키 → wordBook.bookId — NOT NULL
  • userId — varchar2(50) — 외래 키 → wordBook.userId

tbl_member_auth

  • userId — varchar2(50) — 외래 키 → Member.userId
  • auth — varchar2(50)

wordBook

  • bookId — number — 기본 키 — NOT NULL
  • folderId — number — 외래 키 → Folder.folderId — NOT NULL
  • userId — varchar2(50) — 외래 키 → Folder.userId
  • wordTitle — varchar2(100)