1
Tables (5)
Untitled (회원)
- Key (id) — varchar2(11) — Primary key — NOT NULL — 아이디
- Field (password) — varchar2(20) — NOT NULL — 비밀번호
- Field (nickname) — varchar2(18) — NOT NULL — 닉네임
- Field (phone) — number — NOT NULL — 전화번호
- Field (email) — varchar2(25) — NOT NULL — 이메일
- Field (address) — varchar2(100) — NOT NULL — 주소
- Field (birthdate) — varchar2(8) — 생년월일
- Field (gender) — char(2) — 성별
- Field (grade) — number — NOT NULL — 회원등급
Untitled (문의)
- Key (qno) — number — Primary key — NOT NULL — 번호
- Key (id) — varchar2(11) — Foreign key → Untitled.Key — NOT NULL — 아이디
- Field (title) — varchar2(50) — NOT NULL — 제목
- Field (contents) — varchar2(600) — NOT NULL — 내용
- Field (regdate) — date — NOT NULL — 등록일자
Untitled (답변)
- Key (ano) — number — Primary key — NOT NULL — 답변번호
- Key (qno) — number — Foreign key → Untitled.Key — NOT NULL — 번호
- Key (id) — varchar2(11) — Foreign key → Untitled.Key — NOT NULL — 아이디
- Field (answer) — varchar2(600) — NOT NULL — 답변
- Field (regdate) — date — NOT NULL — 등록일자
Untitled (계좌)
- Key (id) — varchar2(11) — Foreign key → Untitled.Key — NOT NULL — 아이디
- Field (bank) — number — NOT NULL — 은행
- Field (account) — number — NOT NULL — 계좌번호
Untitled (마일리지)
- Key (id) — varchar2(11) — Foreign key → Untitled.Key — NOT NULL — 아이디
- Field (mileage) — number — NOT NULL — 마일리지
- Field