asd
Tables (12)
Banner
- banner_id — number — Primary key — NOT NULL
- title — varchar(200)
- image_name — varchar(300)
- link_url — varchar(500)
- start_date — date
- end_date — date
- sort_order — number
Board
- seq — number — Primary key — NOT NULL
- title — varchar(300)
- contents — varchar(4000)
- writer — varchar(30)
- view_count — number
- write_date — timestamp
Bookmark
- bookmark_id — number — Primary key — NOT NULL
- board_seq — number
- bookmark_date — timestamp
Files
- seq — number — Primary key — NOT NULL
- id — varchar(30) — Primary key — NOT NULL
- oriname — varchar(200)
- sysname — varchar(200)
- regdate — timestamp
- parent_seq — number
Members
- id — varchar(30) — Primary key — NOT NULL
- pw — varchar(128)
- name — varchar(30)
- nickname — varchar(50)
- phone — varchar(30)
- email — varchar(100)
- gender — varchar(10)
- dob — varchar(10)
- zipcode — varchar(10) — NOT NULL
- address1 — varchar(200) — NOT NULL
- address2 — varchar(100) — NOT NULL
- regdate — timestamp
- mileage — number — NOT NULL
Notice
- notice_id — number — Primary key — NOT NULL
- title — varchar(200)
- contents — varchar(2000)
- writer — varchar(30)
- view_count — number
- write_date — timestamp
- important — char(1)
Qna
- qid — number — Primary key — NOT NULL
- member_id — varchar(30)
- pw — varchar(30)
- title — varchar(200)
- contents — varchar(2000)
- write_date — timestamp
- status — varchar(20)
Reply
- seq — number — Primary key — NOT NULL
- board_seq — number — NOT NULL
- parent_seq — number
- writer — varchar(30)
- contents — varchar(900)
- write_date — timestamp
Reservation
- seq — VARCHAR(255) — Primary key — NOT NULL
- id2 — varchar(30) — Primary key — NOT NULL
- reserevid — varchar(30)
- reservedate — timestamp
- price — number
- check_in — date
- check_out — date
- guestnum — number
- status — varchar(20)
- mileage — number — NOT NULL
Review
- seq — number — Primary key — NOT NULL
- member_id — varchar(30)
- target_type — varchar(20)
- target_id — number
- contents — varchar(1000)
- rating — number(2,1)
- reg_date — timestamp
Wishlist
- wishlist_id — number — Primary key — NOT NULL
- member_id — varchar(30)
- target_type — varchar(20)
- target_id — number
- reg_date — timestamp
attendance
- attendance_id — number — Primary key — NOT NULL
- member_id — varchar(30)
- attendance_date — date — NOT NULL
- stampdays — number — NOT NULL