sdaawsd

Tables (13)

article

  • article_id — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • content — longtext — NOT NULL
  • location_x — double
  • location_y — double
  • title — varchar(255) — NOT NULL
  • board_id — bigint(20) — Foreign key → board.board_id
  • member_id — bigint(20) — Foreign key → member.member_id

article_image

  • article_image_id — bigint(20) — Primary key — NOT NULL
  • article_image_name — varchar(255)
  • path — varchar(255)
  • uuid — varchar(255)
  • article_id — bigint(20) — Foreign key → article.article_id

board

  • board_id — bigint(20) — Primary key — NOT NULL
  • board_type — varchar(255) — NOT NULL
  • board_name — varchar(255) — NOT NULL

comment

  • comment_id — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • content — varchar(255)
  • article_id — bigint(20) — Foreign key → article.article_id
  • member_id — bigint(20) — Foreign key → member.member_id

common_member

  • mid — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • email — varchar(255) — NOT NULL
  • from_social — bit(1) — NOT NULL
  • mobile — varchar(255)
  • name — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)

common_member_role_set

  • common_member_mid — bigint(20) — Foreign key → common_member.mid — NOT NULL
  • role_set — int(11)

hibernate_sequence

  • next_not_cached_value — bigint(21) — NOT NULL
  • minimum_value — bigint(21) — NOT NULL
  • maximum_value — bigint(21) — NOT NULL
  • start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
  • increment — bigint(21) — NOT NULL — increment value
  • cache_size — bigint(21) — NOT NULL
  • cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
  • cycle_count — bigint(21) — NOT NULL — How many cycles have been done

item

  • item_id — bigint(20) — Primary key — NOT NULL
  • city — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • item_name — varchar(255)
  • made_at — varchar(255)
  • price — int(11) — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id

member

  • member_id — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • city — varchar(255)
  • street — varchar(255)
  • zipcode — varchar(255)
  • email — varchar(255)
  • member_role — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • point — int(11) — NOT NULL

movie

  • mno — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • title — varchar(255)

movie_image

  • inum — bigint(20) — Primary key — NOT NULL
  • img_name — varchar(255)
  • path — varchar(255)
  • uuid — varchar(255)
  • movie_mno — bigint(20) — Foreign key → movie.mno

recommend

  • recommend_id — bigint(20) — Primary key — NOT NULL
  • article_id — bigint(20) — Foreign key → article.article_id
  • member_id — bigint(20) — Foreign key → member.member_id

review

  • reviewnum — bigint(20) — Primary key — NOT NULL
  • moddate — datetime(6)
  • regdate — datetime(6)
  • grade — int(11) — NOT NULL
  • text — varchar(255)
  • member_mid — bigint(20) — Foreign key → common_member.mid
  • movie_mno — bigint(20) — Foreign key → movie.mno