member
Tables (10)
MEMBER (회원가입-데이터)
- PK (Ko_Name) — Type — Primary key — NOT NULL
- EMAIL (이메일) — VARCHAR(30)
- eMail_select (이메일 주소) — VARCHAR(50)
- chked1 (약관동의1) — BOOLEAN
- chked2 (약관동의2) — BOOLEAN
- chked3 (약관동의3) — BOOLEAN
- chked4 (약관동의4) — BOOLEAN
- chked5 (약관동의5) — BOOLEAN
- user (Field) — object
Membership_Registration_Data
- UserID — VARCHAR(50)
- UserPassword — VARCHAR(50) — NOT NULL
- eMail — VARCHAR(50) — NOT NULL
- eMail_Address — VARCHAR(50) — NOT NULL
- chked1 — BOOLEAN — NOT NULL
- chked2 — BOOLEAN — NOT NULL
- chked3 — BOOLEAN — NOT NULL
- chked4 — BOOLEAN — NOT NULL
- chked5 — BOOLEAN — NOT NULL
Pick
- ID — INT
- UserID — VARCHAR(50) — Foreign key → User.UserID
Play_Music
- ID — INT
- UserID — VARCHAR(50) — Foreign key → User.UserID
Playlist
- ID — INT
- UserID — VARCHAR(50) — Foreign key → User.UserID
User
- UserID — VARCHAR(50)
- Membership_Registration_Data_UserID — VARCHAR(50) — Foreign key → Membership_Registration_Data.UserID
pick
- PK (Ko_Name) — Type — Foreign key → user.PK — NOT NULL
playlist
- PK (Ko_Name) — Type — Foreign key → user.PK — NOT NULL
playmusic
- PK (Ko_Name) — Type — Foreign key → user.PK — NOT NULL
user
- PK (Ko_Name) — Type — Foreign key → MEMBER.PK — NOT NULL
- pick (Field) — Object
- playlist (Field2) — Object
- playmusic (Field3) — Object