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