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