다나와 프로젝트
테이블 (5)
ComList
- ComModelID — varchar(255) — 기본 키 — NOT NULL
- ComModelName — varchar(255) — 외래 키 → ComListPrint.ComModelName — NOT NULL
- Company — varchar(255) — NOT NULL
- LowPrice — int(8)
ComListPrint
- ComModelName — varchar(255) — 기본 키 — NOT NULL
- LowPriceLink — int(16) — NOT NULL
- ScreenSize — float(8) — NOT NULL
- CPUNum — varchar(50)
- Revolution — varchar(50)
- FrameRate — int(4)
- RamType — varchar(50)
- RamSize — int(4)
- SSDType — varchar(50)
- SSDSize — int(8)
- HDDSize — int(8)
- GPU — varchar(255)
- VRAM — int(4)
- Bl_ver — int(4)
- WebCam — int(4)
- NumPad — int(4)
- Battery — int(8) — NOT NULL
- Platform — varchar(50)
- Thickness — float(8)
- Weight — float(8) — NOT NULL
- Color — varchar(50)
- Option_1 — varchar(255)
- Option_2 — varchar(255)
PhoneList
- PhoneModelID (PhoeneModelID) — varchar(255) — 기본 키 — NOT NULL
- PhoneModelName — varchar(255) — 외래 키 → PhoneListPrint.PhoneModelName — NOT NULL
- Company — varchar(255) — NOT NULL
- LowPrice — int(8) — NOT NULL
PhoneListPrint
- PhoneModelName — varchar(255) — 기본 키 — NOT NULL
- PhoneType — int(4) — NOT NULL
- Platform — varchar(255) — NOT NULL
- ScreenSize — int(8) — NOT NULL
- ScreenType — varchar(50)
- Revolution — varchar(50)
- PPI — int(8)
- FrameRate — varchar(50)
- RamSize — int(4)
- MemSize — int(8)
- 5G — int(4)
- Bl_ver — int(4)
- BackCam_pix — int(8)
- BackCam_ap — float(8)
- BackCam_Rev — int(8)
- OIS — int(4)
- FrontCam_Rev — int(8)
- FingerPrint — int(4)
- Add_Mem — int(4)
- ChargeType — varchar(50)
- Battery — int(8)
- Max_Charge — int(8)
- Weight — float(8) — NOT NULL
userData
- userName — varchar(255) — 기본 키 — NOT NULL
- ComModelID — varchar(255) — 외래 키 → ComList.ComModelID — NOT NULL
- ComModelName — varchar(255) — 외래 키 → ComList.ComModelName — NOT NULL
- PhoneModelID (PhoeneModelID) — varchar(255) — 외래 키 → PhoneList.PhoneModelID — NOT NULL
- PhoneModelName — varchar(255) — 외래 키 → PhoneList.PhoneModelName — NOT NULL
- userJob — varchar(50) — NOT NULL
- userPref — int(4) — NOT NULL
- userTypeA — varchar(50)
- userTypeB — float(8)
- userTypeC — int(4)
- userTypeD — float(8)