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 (파일명)