정처기-erd
테이블 (4)
emart_admin_page
- id — VARCHAR(255) — NOT NULL
- admin_user_id — VARCHAR(255) — 외래 키 → emart_admin_user.id — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- read_count — INT
- created_at — DATETIME
- Key — 외래 키 → emart_admin_user.Key — NOT NULL
emart_admin_user
- id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — 외래 키 — NOT NULL
- emart_admin_name — VARCHAR(255)
- seller_id — VARCHAR(255)
- hand_phone_number — VARCHAR(255)
- checked_in_name — VARCHAR(20)
- registered_at — DATETIME
- checked_in_email — VARCHAR(255)
- checked_in_birth_date — VARCHAR(255)
- Key — 외래 키 → emart_user.id — NOT NULL
emart_user
- id — 기본 키 — NOT NULL
- account_name — VARCHAR(255) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- gender — VARCHAR(20)
- birth — DATE
- phone — VARCHAR(20)
- use_terms — VARCHAR(255)
- created_at — DATETIME — NOT NULL
user_agreements
- id — 기본 키 — NOT NULL
- user_id — VARCHAR(255) — 외래 키 — NOT NULL
- agreement_id — BIGINT
- agreed — BOOLEAN
- agreed_at — DATETIME
- Key — 외래 키 → emart_user.id — NOT NULL