애정연구소
테이블 (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)