NewUpDownBurger

Tables (9)

MEMBER

  • MEMBER_ID — NUMBER — Primary key — NOT NULL
  • 아이디 (ID) — VARCHAR2(50) — NOT NULL
  • 비밀번호 (PASSWORD) — VARCHAR2(50) — NOT NULL
  • 이름 (NAME) — VARCHAR2(50) — NOT NULL
  • 주소 (ADDR) — VARCHAR2(100) — NOT NULL
  • 이메일 (EMAIL) — VARCHAR2(100) — NOT NULL
  • 전화번호 (PHONE) — VARCHAR2(100) — NOT NULL
  • 회원 종류 (MEMBER_FLAG) — NUMBER — NOT NULL
  • 회원 구분 (MEMBER_TOMB) — NUMBER — NOT NULL
  • 가입일 (MEMBER_DATE) — DATE — NOT NULL

POST

  • POST_ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • 제목 (TITLE) — VARCHAR2(50) — NOT NULL
  • 내용 (CONTENT) — VARCHAR2(4000)
  • 이름 (NAME) — VARCHAR2(50) — NOT NULL
  • 사진 (PICTURE) — VARCHAR2(200)
  • 조회수 (HIT) — NUMBER — NOT NULL
  • 말머리 (POST_FLAG) — NUMBER — NOT NULL
  • 신고 수 (POST_FLAG2) — NUMBER — NOT NULL
  • 게시글 구분 (POST_TOMB) — NUMBER — NOT NULL
  • 좋아요 수 (POST_GREAT) — NUMBER — NOT NULL
  • 작성일 (POST_DATE) — DATE — NOT NULL

REPLY

  • Key — Primary key — NOT NULL
  • POST_ID — NUMBER — Foreign key → POST.POST_ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → POST.MEMBER_ID — NOT NULL
  • 내용 (CONTENT) — VARCHAR2(4000) — NOT NULL
  • 이름 (NAME) — VARCHAR2(50) — NOT NULL
  • 댓글 신고 (REPLY_FLAG) — NUMBER — NOT NULL
  • 댓글 구분 (REPLY_TOMB) — NUMBER — NOT NULL
  • 작성일 (REPLY_DATE) — DATE — NOT NULL

Untitled (POST_FLAG2)

  • POST_ID — NUMBER — Foreign key → POST.POST_ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → POST.MEMBER_ID — NOT NULL
  • Field (POST_FLAG2) — NUMBER — NOT NULL

Untitled (NOTIFICATION)

  • Key (NOTIFICATION_ID) — NUMBER — Primary key — NOT NULL
  • Field (TITLE) — VARCHAR2(500) — NOT NULL
  • Field (CONTENT) — VARCHAR2(4000) — NOT NULL
  • Field (PICTURE) — VARCHAR2(4000)
  • Field (NOTIFICATION_FLAG) — NUMBER — NOT NULL
  • Field (NOTIFICATION_DATE) — DATE — NOT NULL

Untitled (BRAND)

  • Key (BRAND_ID) — NUMBER — Primary key — NOT NULL
  • Field (BRAND_NAME) — VARCHAR2(50) — NOT NULL
  • Field2 (BRAND_MENU) — VARCHAR2(500) — NOT NULL
  • Field3 (BRAND_PRICE) — NUMBER — NOT NULL
  • Field (BRAND_GUIDE) — VARCHAR2(500
  • Field (BRAND_PICTURE) — VARCHAR2(500)
  • Field (BRAND_FLAG) — NUMBER — NOT NULL
  • Field (BRAND_DATE) — DATE — NOT NULL

Untitled (REQUEST)

  • MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • Key (BRAND_ID) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (REQUEST_ID) — NUMBER — NOT NULL
  • Field (REQUEST_TIMED) — DATE — NOT NULL

Untitled (ATTECHED_FILE)

  • Field (ID) — NUMBER — NOT NULL
  • Field2 (ORIGINALFILE) — VARCHAR2(300) — NOT NULL
  • Field3 (SAVEDFILE) — VARCHAR2(300 — NOT NULL

Untitled2 (GREAT)

  • POST_ID — NUMBER — Foreign key → POST.POST_ID — NOT NULL
  • MEMBER_ID — NUMBER — Foreign key → POST.MEMBER_ID — NOT NULL
  • Field3 (GREAT_FLAG) — NUMBER — NOT NULL