KoreaTrip

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
  • 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
  • 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