PrePayApp
Tables (10)
ChargeRequest (충전 요청)
- charge_request_id (요청아이디) — BIGINT — Primary key — NOT NULL
- team_store_id (팀의가맹점아이디) — BIGINT — Foreign key → Team_Store.team_store_id — NOT NULL
- status (상태) — VARCHAR
- request_price (요청가격) — INT
- request_date (일자) — BIGINT
RefundRequest (환불요청)
- refund_request_id (요청아이디) — BIGINT — Primary key — NOT NULL
- order_history_id (주문내역아이디) — BIGINT — Foreign key → order_history.order_history_id — NOT NULL
- team_store_id (팀의가맹점아이디) — BIGINT — Foreign key → Team_Store.team_store_id — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
- status (상태) — VARCHAR
- request_price (요청가격) — INT
- request_date (일자) — BIGINT
Store (가맹점)
- store_id (가맹점아이디) — BIGINT — Primary key — NOT NULL
- store_name (이름) — VARCHAR
- address (주소) — VARCHAR
- type (업종) — VARCHAR
- user_register_permission (유저가입허용) — TINYINT
- longitude (식당 경도) — FLOAT
- latitude (식당 위도) — FLOAT
Team (팀)
- team_id (그룹아이디) — BIGINT — Primary key — NOT NULL
- teamInitializer (유저pk) — BIGINT — Foreign key → User.user_id — NOT NULL
- team_name (이름) — VARCHAR
- public_team (public여부) — INT
- team_password (그룹 비밀번호) — VARCHAR
- daily_price_limit (일일한도) — INT
- count_limit (주문횟수제한) — INT
- team_message (그룹설명) — VARCHAR
- image_url (이미지 url) — VARCHAR
- color (색깔) — VARCHAR
- code_gen_date (그룹 비밀번호 생성일자) — BIGINT
Team_Store (팀의 가맹점)
- team_store_id (팀의가맹점아이디) — BIGINT — Primary key — NOT NULL
- team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
- store_id (가맹점아이디) — BIGINT — Foreign key → Store.store_id — NOT NULL
- team_store_balance (잔액) — INT
User (유저)
- user_id (유저pk) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR
- user_password (비밀번호) — VARCHAR
- nickname (닉네임) — VARCHAR
User_Team (유저의 팀)
- user_group_id (유저의팀아이디) — BIGINT — Primary key — NOT NULL
- team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
- position (직책) — INT
- privilege (회식결제권한) — INT
- usage (사용한 금액) — INT
- usage_count (사용횟수) — INT
- like (좋아요) — INT
detail_history (상세내역)
- detail_history_id (상세내역아이디) — BIGINT — Primary key — NOT NULL
- order_history_id (주문내역아이디) — BIGINT — Foreign key → order_history.order_history_id — NOT NULL
- product (품목) — VARCHAR
- detail_price (상세가격) — INT
- quantity (갯수) — INT
order_history (주문내역)
- order_history_id (주문내역아이디) — BIGINT — Primary key — NOT NULL
- team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
- store_id (가맹점아이디) — BIGINT — Foreign key → Store.store_id — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
- order_date (일시) — BIGINT
- total_price (금액) — INT
- refund_status (환불상태) — INT
- company_dinner (회식여부) — TINYINT
- withdraw (입출금여부) — TINYINT
party_request (회식권한요청)
- party_request_id — BIGINT — Primary key — NOT NULL
- user_group_id (유저의그룹아이디) — BIGINT — Foreign key → User_Team.user_group_id — NOT NULL
- request_date (요청일시) — BIGINT
- party_request_status (상태) — VARCHAR
- status_changed_date (상태변경일시) — BIGINT