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