애정연구소

테이블 (4)

권한 (authority)

  • member_id (Key3) — INT — 외래 키 → 회원.member_id — NOT NULL
  • authority_name (Field) — VARCHAR(50)

이메일 인증 (mail_auth)

  • member_id (Key3) — INT — 외래 키 → 회원.member_id — NOT NULL
  • auth_code (Field) — INT

커플 (couple)

  • couple_id (Key) — INT — 기본 키 — NOT NULL
  • member_id (Key2) — INT — 외래 키 → 회원.member_id — NOT NULL
  • member_id_slave (Field4) — INT
  • member_code (Field) — CHAR(6)
  • member_code_status (Field5) — CHAR(1)
  • start_date (Field2) — DATE
  • reg_date (Field7) — DATE
  • reg_worker (Field8) — VARCHAR(20)
  • mod_date (Field9) — DATE
  • mod_worker (Field10) — VARCHAR(20)
  • couple_status (Field3) — VARCHAR(10)
  • Field6

회원 (member)

  • member_id (Key) — INT — 기본 키 — NOT NULL
  • member_email (Field2) — VARCHAR(20)
  • password (Field3) — VARCHAR(100)
  • nickname (Field10) — VARCHAR(50)
  • gender (Field) — CHAR(1)
  • age (Field9) — INT
  • reg_ip (Field8) — VARCHAR(128) — NOT NULL
  • reg_date (Field4) — DATE
  • reg_worker (Field5) — VARCHAR(20)
  • mod_date (Field6) — DATE
  • mod_worker (Field7) — VARCHAR(20)