delivery

Tables (5)

BOARD (Untitled3)

  • BOARD_ID (게시판번호) — INT — Primary key — NOT NULL
  • USER_ID (회원아이디) — VARCHAR(11) — Foreign key → USER.USER_ID — NOT NULL
  • DELIVERY_NYUMBER (운송장번호) — INT — Foreign key → USER.DELIVERY_NYUMBER — NOT NULL
  • BOARD_TITLE (게시판제목) — VARCHAR(20) — NOT NULL
  • BOARD_WRITER (작성자) — VARCHAR(11)
  • BOARD_VIEWS (조회수) — INT
  • BOARD_CONTENT (게시판본문) — TEXT
  • BOARD_DATE (작성일) — DATE
  • BOARD_DELETE (게시판삭제여부) — INT

COMMENT (Untitled4)

  • COMMENT_ID (댓글번호) — INT — Primary key — NOT NULL
  • BOARD_ID (게시판번호2) — INT — Foreign key → BOARD.BOARD_ID — NOT NULL
  • USER_ID (회원아이디) — VARCHAR(11) — Foreign key → BOARD.USER_ID — NOT NULL
  • DELIVERY_NYUMBER (운송장번호) — INT — Foreign key → BOARD.DELIVERY_NYUMBER — NOT NULL
  • BOARD_ID (게시판번호) — INT
  • COMMENT_CLASS (대댓글계층) — INT
  • COMMNET_GROUPOD (대댓글부모번호) — INT
  • COMMENT_WRITER (작성자) — VARCHAR(11)
  • COMMENT_CONTENT (댓글본문) — TEXT
  • COMMENT_DATE (작성일) — DATE
  • Field

COMPANY (Untitled)

  • COMPANY_NUMBER (택배사번호) — INT — Primary key — NOT NULL
  • DELIVERY_NYUMBER (운ㄴ송장번호) — INT — Foreign key → DELIVERY.DELIVERY_NYUMBER — NOT NULL
  • COMPANY_NAME (택배사이름) — VARCHAR2(25)

DELIVERY (Untitled2)

  • DELIVERY_NYUMBER (운송장번호) — INT — Primary key — NOT NULL
  • DELIVERY_COMPANY (택배사번호) — INT
  • USER_ID (회원아이디) — VARCHAR(11)

USER (Untitled5)

  • USER_ID (회원아이디) — VARCHAR(11) — Primary key — NOT NULL
  • DELIVERY_NYUMBER (운송장번호) — INT — Foreign key → DELIVERY.DELIVERY_NYUMBER — NOT NULL
  • USER_PASSWORD (회원비밀번호) — VARCHAR(11)
  • USER_PHONE (회원연락처) — VARCHAR(14)
  • USER_EMAIL (회원이메일) — VARCHAR25
  • USER_SEX (회원성별) — INT
  • USER_NAME (회원이름) — VARCHAR(10)
  • USER_NICKNAME (회원닉네임) — VARCHAR2(10)
  • USER_BRITH (회원생일) — DATE
  • Field