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