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