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)