announce
Tables (3)
member (Untitled)
- Key (member_id) — int — Primary key — NOT NULL
- Field (login_id) — varchar(50) — NOT NULL
- Field2 (member_name) — varchar(50) — NOT NULL
- Field3 (member_pwd) — varchar(50) — NOT NULL
- Field4 (member_email) — varchar(50)
- Field5 (member_dept) — INT — NOT NULL
- Field6 (member_phone) — varchar(50)
notice (Untitled2)
- Key (notice_id) — int — Primary key — NOT NULL
- Field (notice_title) — varchar(500) — NOT NULL
- Field2 (notice_content) — varchar(5000) — NOT NULL
- Field4 (notice_view) — int — NOT NULL
- Field5 (notice_datetime) — datetime — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
qna (Untitled3)
- Key (qna_id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Key (notice_id) — int — Foreign key → notice.Key — NOT NULL
- Field3 (qna_title) — varchar(500) — NOT NULL
- Field4 (qna_content) — varchar(5000) — NOT NULL
- Field5 (qna_datetime) — datetime — NOT NULL