sda
Tables (7)
article
- article_id — bigint(20) — Primary key — NOT NULL
- moddate — datetime(6)
- regdate — datetime(6)
- board_type — varchar(255) — NOT NULL
- content — longtext — NOT NULL
- location_x — double
- location_y — double
- title — varchar(255) — NOT NULL
- 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
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
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)
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