BrandNew
Tables (10)
BISCUIT_SHOP (비스킷샵)
- pno (상품번호) — NUMBER — Primary key — NOT NULL
- pname (상품이름) — VARCHAR
- psort (상품분류) — NUMBER
- price (가격) — NUMBER
- regdate (생성/수정일) — DATE
- pxpiration_period (만료기간) — DATE
BOARDS (게시판)
- bno (기본 키) — NUMBER — Primary key — NOT NULL — 게시판 고유 번호
- userid (아이디) — VARCHAR — Foreign key → USERS.userid
- title (글 제목) — VARCHAR
- content (글 본문) — VARCHAR
- regdate (생성/수정) — DATE
- view_cnt (조회수) — NUMBER
- like_cnt (좋아요수) — NUMBER
- filename (파일명) — VARCHAR
COMMENT (댓글)
- cno (기본키()) — NUMBER — Primary key — NOT NULL
- bno (기본 키) — NUMBER — Foreign key → BOARDS.bno — NOT NULL — 게시판 고유 번호
- userid (아이디) — VARCHAR — Foreign key → BOARDS.userid
- regdate (생성일/수정일) — DATE
- comment (댓글내용) — VARCHAR
Diary (다이어리)
- dno (기본 키) — NUMBER — Primary key — NOT NULL
- userid (아이디) — VARCHAR — Foreign key → USERS.userid
- dname (타이틀) — VARCHAR
- start_date (시작일) — DATE
- end_date (마지막일) — DATE
FRIEND COMMENT (일촌평)
- friend_no (기본키) — NUMBER — Primary key — NOT NULL
- fno (key) — Foreign key → FRIENDS.fno — NOT NULL
- userid (아이디2) — VARCHAR — Foreign key → FRIENDS.userid
- comment (내용) — VARCHAR
FRIENDS (과자들)
- fno (key) — Primary key — NOT NULL
- userid (아이디2) — VARCHAR — Foreign key → USERS.userid
- freindid (친구아이디) — VARCHAR
- fnickname (친구명) — VARCHAR
- regdate (생성/수정일) — DATE
MUSIC (음악)
- mno (기본 키) — NUMBER — Primary key — NOT NULL
- userid (아이디) — VARCHAR — Foreign key → USERS.userid
- mname (곡명) — VARCHAR
- singer_name (가수명) — VARCHAR
- filename (파일이름) — VARCHAR
PAYMENT (결제)
- name (실명) — VARCHAR
- birthday (주민번호) — VARCHAR
- phone (전화번호) — VARCHAR
- regdate (구입일) — DATE
USERS (유저)
- userid (아이디) — VARCHAR — Primary key
- password (패스워드) — VARCHAR
- realname (실명) — VARCHAR
- brithday (생년월일) — VARCHAR
- phone (전화번호) — VARCHAR
- regdate (생성일) — DATE
- nickname (친구명) — VARCHAR
- biscuit (비스킷(가상화폐)) — NUMBER
photo (사진첩)
- ptno (포토기본키) — NUMBER — Primary key — NOT NULL
- userid (아이디) — VARCHAR — Foreign key → USERS.userid
- content (글 본문) — VARCHAR
- regdate (생성/수정) — DATE
- view_cnt (조회수) — NUMBER
- like_cnt (좋아요수) — NUMBER
- filename (파일명)