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