GG-Pigs Application
Tables (9)
Copy Of Copy Of verification_mail (history_log)
- verification_mail_id (history_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- name (title) — varchar(128) — History's title
- Field (content) — varchar(512) — History's content
- user_id — bigint — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
- verification_mail_id (history_type_id) — bigint — Foreign key → Copy Of verification_mail.verification_mail_id — NOT NULL — AUTO_INCREMENT
Copy Of user (user_salt)
- user_id (user_salt_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- is_authenticated (salt) — varchar(255) — NOT NULL — Salt for hash algorithm
- Field (digest) — varchar(255) — NOT NULL — Digest of hash algorithm
- user_id — bigint — Foreign key → user.user_id — NOT NULL — The user
Copy Of verification_mail (history_log_type)
- verification_mail_id (history_type_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- name (type) — varchar(32) — NOT NULL — History's type
advertisement
- advertisement_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- title — varchar(32) — NOT NULL — Title of ad
- detail_description — varchar(128) — Detail description of ad
- Field (keywords) — varchar(128) — The keywords of ad
- image_path — varchar(128) — Path of stored image path
- site_url — varchar(255) — Site url of ad
- row_position — varchar(8) — Row position of ad
- column_position — varchar(8) — Column position of ad
- is_activated — char(1) — NOT NULL — Whether the status is active or not / (N: DEACTIVATED, Y: ACTIVATED)
- user_id — bigint — Foreign key → user.user_id — The member who registers this advertisement
- advertisement_type_id — bigint — Foreign key → advertisement_type.advertisement_type_id — NOT NULL — The type of advertisement
advertisement_request
- advertisement_request_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- title — varchar(32) — NOT NULL — Title of ad
- detail_description — varchar(128) — Detail description of ad
- Field (keywords) — varchar(128) — Th keywords of ad
- image_path — varchar(128) — Path of stored image path
- site_url — varchar(255) — Site url of ad
- row_position — varchar(8) — Row position of ad
- column_position — varchar(8) — Column position of ad
- review_status — varchar(32) — NOT NULL — Whether or not the review has been carried out / Enum type in java ('APPROVAL', 'NON_APPROVAL', 'PENDING')
- reviewer — varchar(32) — The employee who reviewed the requested advertisement.
- started_date — DATE — The date your post will be started
- finished_date — DATE — The date your post will be finished
- user_id — bigint — Foreign key → user.user_id — The member who requests to register advertisement
- advertisement_type_id — bigint — Foreign key → advertisement_type.advertisement_type_id — NOT NULL — The type of requested advertisement
advertisement_type
- advertisement_type_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- type — varchar(8) — NOT NULL — Advertisement's type / Enum type in java ('R1', 'R2', 'R3', 'R4', 'R5', 'R6')
- width — varchar(8) — NOT NULL — Advertisement's width
- height — varchar(8) — NOT NULL — Advertisement's height
common (COMMON)
- created_date (CREATED_DATE) — DATETIME — When the data is created
- updated_date (UPDATED_DATE) — DATETIME — When the data is updated
user
- user_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- name — varchar(32) — User's name
- email — varchar(64) — NOT NULL — UNIQUE / User's email
- phone — varchar(16) — UNIQUE / User's phone
- role — varchar(32) — NOT NULL — User's authorization / Enum type in java ('ROLE_MEMBER', 'ROLE_ADMIN')
- oauth_type — varchar(32) — User's oauth type / Enum type in java ('KAKAO', 'NAVER', 'GOOGLE')
- is_activated — char(1) — NOT NULL — Whether the status is active or not / (N: DEACTIVATED, Y: ACTIVATED)
- is_authenticated — char(1) — NOT NULL — Whether this user is authenticated or not / (N: NOT AUTHENTICATED, Y: AUTHENTICATED)
verification_mail
- verification_mail_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- name (to_email) — varchar(32) — NOT NULL — The receiver's email
- email (from_email) — varchar(32) — NOT NULL — The sender's email
- phone (verification_code) — varchar(16) — NOT NULL — The code for veification
- Field (subject) — varchar(32) — Subject of mail
- Field (content) — varchar(255) — Content of mail
- role (status) — varchar(16) — NOT NULL — The result-status of verification mail
- oauth_type (sent_date) — date — NOT NULL — Email sent date