test

테이블 (3)

Untitled (POST)

  • Key (NO) — NUMBER(50) — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR2(50)
  • Field (CONTENT) — VARCHAR2(255)
  • Field (REGDATE) — DATE
  • Field (LOCATION) — VARCHAR2(50)
  • Key (ID) — VARCHAR2(50) — 외래 키 → 회원.Key — NOT NULL

Untitled (FRIEND)

  • Key (FNAME) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (FPOS) — VARCHAR2(50)

회원 (MEMBER)

  • Key (ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (PWD) — VARCHAR2(50)
  • Field (NAME) — VARCHAR2(50)
  • Field (BIRTH) — DATE
  • Field (GENDER) — NUMBER(1)
  • Field (TEL) — VARCHAR2(50)
  • Field (POS) — VARCHAR2(50)
  • Key (FNAME) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL