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)