디에스티
테이블 (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