members_info

Tables (6)

ADDRESS

  • PK (AD_PK) — VARCHAR(20) — Primary key — NOT NULL
  • FK (ID_FK) — VARCHAR(20) — Foreign key → MEMBER_INFO.PK — NOT NULL
  • FK (S_FK) — VARCHAR(20) — Foreign key → STATE.PK — NOT NULL
  • FK (T_FK) — VARCHAR(20) — Foreign key → TOWN.PK — NOT NULL

HOBBY

  • PK (HB_PK) — VARCHAR(20) — Primary key — NOT NULL
  • Field (CATEGORY) — VARCHAR(20)

ID_HOBBY

  • PK (ID_HB_PK) — VARCHAR(20) — Primary key — NOT NULL
  • FK (ID_FK) — VARCHAR(20) — Foreign key → MEMBER_INFO.PK — NOT NULL
  • FK (HB_FK) — VARCHAR(20) — Foreign key → HOBBY.PK — NOT NULL

MEMBER_INFO

  • PK (ID_PK) — VARCHAR(20) — Primary key — NOT NULL
  • Field (Name) — VARCHAR(20)
  • Field (Age) — VARCHAR(20)
  • Field (Gender) — VARCHAR(20)
  • Field (Mobile) — VARCHAR(20)
  • Field (Email) — VARCHAR(20)

STATE

  • PK (S_PK) — VARCHAR(20) — Primary key — NOT NULL
  • Field (State_Name) — VARCHAR(20)

TOWN

  • PK (T_PK) — VARCHAR(20) — Primary key — NOT NULL
  • Field (Town_Name) — VARCHAR(20)