erd

Tables (3)

Copy Of TBL_MEMBER (주문)

  • PK키 (PK_ORDER) — NUMBER — Primary key — NOT NULL — SEQ_ORDER로 자동증가
  • PK키 (PK_MEMBER) — NUMBER — Foreign key → TBL_MEMBER.PK키 — NOT NULL — SEQ_MEMBER로 자동증가

TBL_MEMBER (회원)

  • PK키 (PK_MEMBER) — NUMBER — Primary key — NOT NULL — SEQ_MEMBER로 자동증가
  • 이름 (MEMBER_NAME) — VARCHAR2(255) — NOT NULL
  • 나이 (MEMBER_AGE) — NUMBER — CURRENT_TIMESTAMP
  • 가입일 (MEMBER_CREATE_AT) — TIMESTAMP — NOT NULL
  • Field

TBL_PROFILE (프로필)

  • Key — Primary key — NOT NULL
  • PK키 (PK_MEMBER2) — NUMBER — Foreign key → TBL_MEMBER.PK키 — NOT NULL — SEQ_MEMBER로 자동증가
  • FK키 (PK_MEMBER) — NUMBER — NOT NULL — SEQ_MEMBER 자동증가
  • PROFILE)NAME (파일명) — VARCHAR2(255)
  • PROFILE_PATH (파일경로) — VARCHAR2(255)