milkT

Tables (3)

milk_mail_file

  • idx — int — Primary key — NOT NULL
  • mail_idx — int
  • title — varchar(200)
  • orgFile — varchar(200)
  • saveFile — varchar(200)
  • reg_date — datetime
  • mail_idx (mail_idx2) — int — Foreign key — NOT NULL

milk_member

  • member_idx — int — Primary key — NOT NULL
  • member_name — varchar(20) — NOT NULL
  • member_user_id — varchar(45) — NOT NULL
  • member_pwd — varchar(45) — NOT NULL
  • member_phone — varchar(45) — NOT NULL
  • member_email — varchar(45) — NOT NULL
  • member_category — varchar(10)
  • member_jender — varchar(20) — NOT NULL
  • member_bitrh — varchar(20) — NOT NULL
  • member_grade — varchar(20)

milk_member_file

  • idx — int — Primary key — NOT NULL
  • member_idx — int
  • orgFile — varchar(200)
  • saveFile — varchar(200)
  • reg_date — datetime
  • member_idx (member_idx2) — int — Foreign key → milk_member.member_idx — NOT NULL