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)