form & form

Tables (3)

mainForm (subForm)

  • formCode — pk — Primary key — NOT NULL
  • memCode — pk — Foreign key → member.memCode — NOT NULL
  • formSubject — not null
  • formContent (formContetn)
  • formState — not null
  • formDate — null
  • itemNeed — not null
  • itemSubject — not null
  • itemType — not null
  • itemReply — not null
  • itemMin — not null
  • itemMax — not null

member

  • memCode — pk — Primary key — NOT NULL
  • memName — not null
  • memId — not null
  • memPassword — not null

response

  • formCode — pk — Foreign key → mainForm.formCode — NOT NULL
  • responseDate — NOT NULL
  • itemReply — NOT NULL