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