trip

Tables (3)

COUNTRY (나라 테이블)

  • COUNTRY_NO — NUMBER — Primary key — NOT NULL — 나라코드
  • COOUNTRY_NAME — VARCHAR2(50) — NOT NULL — 나라명
  • CONTINENT — VARCHAR2(50) — NOT NULL — 대륙명

DS (Untitled)

  • Key — Primary key — NOT NULL

MEMBER (멤버 테이블)

  • MEMBER_NO — NUMBER — Primary key — NOT NULL — 회원번호
  • MEMBER_ID — VARCHAR2(100) — 회원이메일
  • MEMBER_PW — VARCHAR2(100) — NOT NULL — 회원비밀번호
  • PHONE — VARCHAR2(13) — 전화번호
  • NICKNAME — VARCHAR2(30) — 닉네임
  • ROLE — VARCHAR2(10) — NOT NULL — 역할
  • REGISTERED_AT — DATE — NOT NULL — 가입일
  • DELETED_AT — DATE — 탈퇴일
  • DELETED_YN — CHAR(1) — NOT NULL — 탈퇴여부