dd
Tables (4)
T_MEMBER (Untitled)
- ID (Key) — VARCHAR(250) — Primary key — NOT NULL
- PW (Field) — VARCHAR(250)
- NAME (Field2) — VARCHAR(250)
- AGE (Field3) — INT
- GENDER (Field4) — VARCHAR(250)
- PHONENUM (Field5) — VARCHAR(250)
- SIGNUPDATE (Field6) — DATETIME
- TYPE (Field7) — VARCHAR(250)
T_MYLOG (Untitled2)
- LOGNUM (Key) — INT — Primary key — NOT NULL
- ID (Field1) — VARCHAR(250) — Foreign key → T_MEMBER.ID — NOT NULL
- M_NUM1 (Field2) — INT
- M_NUM2 (Field3) — INT
- M_NUM3 (Field4) — INT
- P_NUM (Key2) — INT — Foreign key → T_PERFUME.P_NUM — NOT NULL
T_PERFUME (Untitled3)
- P_NUM (Key) — INT — Primary key — NOT NULL
- P_NAME (Field) — VARCHAR(250)
- P_BRAND (Field2) — VARCHAR(250)
- P_PIC (Field3) — VARCHAR(250)
- P_INTRO (Field4) — VARCHAR(250)
Untitled4
- M_NUM (Key) — INT — Primary key — NOT NULL
- M_ARTIST (Field) — VARCHAR(250)
- M_TITLE (Field2) — VARCHAR(250)