디에스티

테이블 (7)

Admin

  • admin_no — int — 기본 키 — NOT NULL
  • user_name — String
  • id — String
  • password — String
  • role — enum

Inquiry

  • Inquiry_no — int — 기본 키 — NOT NULL
  • Inquiry_type — String
  • company — String
  • Inquiry_name — String
  • Inquiry_title — String
  • Inquiry_email — String
  • Inquiry_phone — int
  • Inquiry_content — String
  • attachment

Post

  • post_no — int — 기본 키 — NOT NULL
  • type — String
  • title — String
  • content — String
  • admin_no — int — 외래 키 → Admin.admin_no — NOT NULL
  • created_at — DATE
  • updated_at — DATE
  • deleted_at — DATE
  • statement — String
  • Inquiry_no — int — 외래 키 → Inquiry.Inquiry_no — NOT NULL
  • writer — string
  • updater — string

agreed (agreed\)

  • agreements_no — int — 외래 키 → agreements.agreements_no — NOT NULL
  • Inquiry_no — int — 외래 키 → Inquiry.Inquiry_no — NOT NULL
  • state — enum

agreements

  • agreements_no — int — 기본 키 — NOT NULL
  • agreements_title — String
  • agreements_cont — String

business

  • business_no (business_no, autoincrement) — int — 기본 키
  • business_name — String
  • business_content — String

product

  • product_no (product_no, autoincrement) — int — 기본 키
  • product_name — String
  • product_content — String