최종
테이블 (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)