OOO_ERD
Tables (3)
contract (Untitled2)
- phone_number (전화번호) — VARCHAR(255) — Primary key — NOT NULL UNIQUE 암호화
- customer_id (사용자 아이디) — VARCHAR(255) — Foreign key → custormers.customer_id — NOT NULL — NOT NULL UNIQUE
- user_id (식별번호) — BIGINT — NOT NULL INCREAMENT
custormers (Untitled)
- customer_id (사용자 아이디) — VARCHAR(255) — Primary key — NOT NULL — NOT NULL UNIQUE
- first_name (이름(성)) — VARCHAR(45) — NOT NULL — NOT NULL
- last_name (이름) — VARCHAR(45) — NOT NULL — NOT NULL
- date_of_birth (생년월일) — DATE — NOT NULL — NOT NULL TIMESTAMP
- gender (성별) — Int(1) — NOT NULL — NOT NULL
- create_date (가입일) — DATE — TIME STAMP NOT NULL
password (Untitled3)
- password_id (Primary Key) — BIGINT — Primary key — NOT NULL — INCREAMENT
- customer_id (사용자 아이디) — VARCHAR(255) — Foreign key → custormers.customer_id — NOT NULL — NOT NULL UNIQUE
- user_password (비밀번호) — VARCHAR(255) — NOT NULL
- salt (소금값) — VARCHAR(255)