ㅋㅋㅋㅋㅅㅂ

Tables (4)

Untitled (게시글)

  • Key (게시글ID) — Primary key — NOT NULL
  • Key (회원ID(FK)) — Primary key — NOT NULL
  • Field (제목)
  • Field (내용)
  • Field2 (게시일)
  • Field (수정일)

Untitled (댓글)

  • Key (댓글ID) — Primary key — NOT NULL
  • Key (회원ID(FK)) — Primary key — NOT NULL
  • Field (게시글ID)
  • Field2 (내용)
  • Field3 (작성일)

Untitled (결제정보)

  • Key (결제ID) — Primary key — NOT NULL
  • Field (회원ID)
  • Field2 (결제금액)
  • Field3 (결제수단)
  • Field4 (결제일)

User (회원 테이블)

  • Key (회원번호) — VARCHAR2(36) — Primary key — NOT NULL
  • Field (이름) — VARCHAR2(30)
  • Field (이메일) — VARCHAR2(50)
  • Field2 (비밀번호) — VARCHAR2(20)
  • Field (성별) — NUMBER(1,0)
  • Field3 (가입일) — TIMESTAMP (6)
  • Field4 (프로필) — NUMBER(1,0)