HowTrip
Tables (6)
board
- board_id — number — Primary key — NOT NULL
- title — varchar2 — NOT NULL
- board_content — varchar2 — NOT NULL
- views — number
- like_cnt — number
- created_time — date — NOT NULL
- update_time — date
- user_id — varchar2 — NOT NULL
board_like
- board_like_id — number — Primary key — NOT NULL
- board_id — number — NOT NULL
- user_id — varchar2 — NOT NULL
bookmark
- bm_id — number — Primary key — NOT NULL
- user_id — varchar2 — NOT NULL
- content_id — number — NOT NULL
- bm_title — varchar2 — NOT NULL
- url_address — varchar2 — NOT NULL
- img_address — varchar2 — NOT NULL
comment
- comment_id — number — Primary key — NOT NULL
- comment_content — varchar2 — NOT NULL
- created_time — date — NOT NULL
- update_time — date
- user_id — varchar2 — NOT NULL
- board_id — number — NOT NULL
comment_reply
- reply_id — number — Primary key — NOT NULL
- reply_content — varchar2 — NOT NULL
- created_time — date — NOT NULL
- update_time — date
- user_id — varchar2 — NOT NULL
- board_id — number — NOT NULL
- comment_id — number — NOT NULL
member
- user_id — varchar2 — Primary key — NOT NULL
- Field (user_pwd) — varchar2 — NOT NULL
- name — varchar2 — NOT NULL
- birth — date — NOT NULL
- gender — varchar2 — NOT NULL
- email — varchar2 — NOT NULL
- tel — number